PL/SQL-Errors [message #3046] |
Mon, 02 September 2002 01:10 |
Christine Pollhaus
Messages: 18 Registered: May 2002
|
Junior Member |
|
|
Hi everybody,
I created the following Procedure:
CREATE OR REPLACE
PROCEDURE NEWUSER (user_in IN VARCHAR2, pw_in IN VARCHAR2, DTS_in IN VARCHAR2, TTS_in IN VARCHAR2)
IS
BEGIN
EXECUTE IMMEDIATE
'CREATE USER '||user_in||' IDENTIFIED BY '||pw_in||' DEFAULT_TABLESPACE '||DTS_in||' TEMPORARY TABLESPACE '||TTS_in||' ';
END;
then I started it in SQL*PLUS.
It shows the followin errors:
SQL> execute newuser ('TEST', 'TEST', 'PROFILE_C', 'TEMP')
BEGIN newuser ('TEST', 'TEST', 'PROFILE_C', 'TEMP'); END;
*
FEHLER in Zeile 1:
ORA-00922: Fehlende oder ungültige Option
ORA-06512: in "PROFILEC.NEWUSER", Zeile 4
ORA-06512: in Zeile 1
What went wrong? I have no idea!?
Thanks for any help!
|
|
|
Re: PL/SQL-Errors [message #3047 is a reply to message #3046] |
Mon, 02 September 2002 01:54 |
Manju
Messages: 10 Registered: November 2000
|
Junior Member |
|
|
Hi,
Jus a quick check on ur code
Do you really need the underscore here for
DEFAULT_TABLESPACE
Pls. check if it is a typo ...
Cheers,
Manju
|
|
|
|