Re: stored procedure

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 25 Oct 1999 14:28:37 +0200
Message-ID: <7v1igf$j4k$1@oceanite.cybercable.fr>

To call a stored procedure with SQL*Plus you have to use the exec statement:

exec create_user('fab','fab');

or a PL/SQL block:

begin
create_user('fab','fab');
end;
/

--
Have a nice day
Michel

Koen Van Tolhuyzen <Koen.VanTolhuyzen_at_cronos.be> a écrit dans le message : 7v1h4a$l2o$1_at_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:28:37 CDT