How to call store procedure in SQL*Plus

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 - 07:35:30 CDT