Results 1 to 2 of 2

Thread: Help executing a package procedure in SYS account; identifier must be declared

  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Help executing a package procedure in SYS account; identifier must be declared

    Help from anybody will be greatly appreciated. I have been trying to execute this package procedure by James Koopmann;

    http://www.databasejournal.com/featu...r---Part-I.htm

    I ran the package script on CTRL_SCHEMA_USER in "SYS" account, and then tried to call the "CREATE_USER" procedure in the same "SYS" account as follows;
    SQL>exec CTRL_SCHEMA_USER.CREATE_USER(XM);

    Oracle keeps telling ME that the "XM" identifier must be declared. Can somebody help me solve this problem? Thanks

  2. #2
    Join Date
    Mar 2009
    Posts
    2

    Problem solved

    Sorry, I got it now. I forgot to surround the string literal XM by single quote charaters as 'XM'. But then, you will still get error; cannot grant QUOTA on the tablespace. Just make sure that you are not granting QUOTA UNLIMITED to temporary tablespace if you are using 10gRel2.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •