Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem with function
Hi Artur,
It works if you create a stored procedure that calls this function:
create or replace procedure proc_name(pLog IN VARCHAR2, Pass IN VARCHAR2,
Created IN DATE) is
v1 number(10):= 0;
begin
v1 := user_add(pLog, Pass, created);
end;
To call the procedure from sql*plus:
execute proc_name('NewUser','Pass', sysdate);
cheers
-- Nicolas SternReceived on Mon Aug 13 2001 - 06:08:40 CDT