Re: How to call store procedure in SQL*Plus

The following will allow you to assign a value:

>var in_para char(100)

execute :in_para := '123';

>execute proc(:in_para)

To see the value:

print in_para

Kenny Gump
OCP 7.3 DBA matthew_so_at_my-dejanews.com wrote in message <7g1mii$7kk$1_at_nnrp1.dejanews.com>...
>Hi all,
> I have written a stored procedure in Oracle. [proc(abc in out
varchar2)]
>The stored procedure will take the same parameter as in and out. However,
how
>can i call the procedure in SQL*PLUS.
>I know that it should call below line
>
>var in_para char(100)
>execute proc(:in_para)
>
>But, how can i assign the value '123' to the in_para??? Just
>in_para:='123'???? Not work!!
>
>Thanks a lot!
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Apr 26 1999 - 11:45:24 CDT