stored procedure

From: Koen Van Tolhuyzen <Koen.VanTolhuyzen_at_cronos.be>
Date: Mon, 25 Oct 1999 14:08:41 +0200
Message-ID: <7v1h4a$l2o$1@news3.Belgium.EU.net>

Hi, I created a stored procedure to create a user, but I keep on getting an error.
Can anyone tell me what is wrong ? I'm using Oracle 8i.

SQL> create or replace PROCEDURE CREATE_USER   2 (p_username IN VARCHAR2
  3 ,p_password IN VARCHAR2)
  4 IS
  5 BEGIN
  6 EXECUTE IMMEDIATE 'CREATE USER ' || p_username || 'IDENTIFIED BY ' || p_password || ';' ;
  7 EXECUTE IMMEDIATE 'GRANT CONNECT TO ' || p_username || ';' ;   8 end;
  9 /

Procedure created.

SQL> call create_user('fab','fab');
call create_user('fab','fab')

*
ERROR at line 1:

ORA-00922: missing or invalid option
ORA-06512: at "SYSTEM.CREATE_USER", line 6
ORA-06512: at line 1

Thanks

Koen
Koen.VanTolhuyzen_at_cronos.be Received on Mon Oct 25 1999 - 07:08:41 CDT