Re: Executing a Oracle Stored Procedure

>I would like to execute the procedure from sqlplus
>Unfortunately the docs dont give a descent example of how to to this
>with an out parm. Here is what I have, but it doesnt seem to work:

Here is the right syntax (also displays result):

SQL> Set serverout on
SQL>
declare
  test number ;
begin
  johns_proc(test) ;
  dbms_output.put_line('Test value:'|| test) ; /* display result */ end ;
/

>BEGIN
>
>DECLARE TEST NUMBER;
>
>EXECUTE johns_proc(TEST);
>
>END
>/
 

>It would also be nice to display the value of TEST to the screen!
>
>thanks in advance
>
>-John

Murthy. Received on Thu Oct 31 1996 - 00:00:00 CET