Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL-Errors
PL/SQL-Errors [message #3046] Mon, 02 September 2002 01:10 Go to next message
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 Go to previous messageGo to next message
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
Re: PL/SQL-Errors [message #3057 is a reply to message #3046] Mon, 02 September 2002 21:52 Go to previous message
Christine Pollhaus
Messages: 18
Registered: May 2002
Junior Member
Dear Manju,

Thanks a lot, you were right!

Regards Christine
Previous Topic: the name of the aplication
Next Topic: How to sum two (or more) records
Goto Forum:
  


Current Time: Thu Mar 28 19:09:18 CDT 2024