Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to call store procedure in SQL*Plus
Write a program like this
declare
v_var_a number(3):=100;
begin
v_var_a := exec procedure(v_var_a);
dbms_output.put_line(to_char(v_var_a));
end;
Good luck
Al Ruiz
matthew_so_at_my-dejanews.com wrote:
> 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 Wed May 05 1999 - 19:44:44 CDT