Re: call Oracle stored procedure

FC wrote:
> Look at the "@" command in the SQL Plus User's Guide.
>
> You can find the docs here:
> http://tahiti.oracle.com/

That would be an external file.

>
> "Jenny" <jwang_at_housing.tamu.edu> wrote in message
> news:at5db7$f38$1_at_news.tamu.edu...
>

>>Need to know how to make a call to Oracle stored procedure from SQL plus.
>>Thanks in advance!
>>
>>Jenny
>>jennyw_at_housing.tamu.edu
>>

exec <procedure_name>. Oracle fixes that into: begin

   <procedure_name>
end;

which you could type yourself, too.

Grtz, Frank Received on Tue Dec 10 2002 - 15:05:27 CST