Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problem with function

Re: Problem with function

From: Nicolas Stern <spip46_at_hotmail.com>
Date: Mon, 13 Aug 2001 13:08:40 +0200
Message-ID: <3b77b539$1@news.psi.ch>

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 Stern
Received on Mon Aug 13 2001 - 06:08:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US