Home » SQL & PL/SQL » SQL & PL/SQL » calling stored proc in a package
calling stored proc in a package [message #21036] Mon, 08 July 2002 08:58 Go to next message
Tracy
Messages: 43
Registered: January 2000
Member
Hi,

Can you please tell me how to call a stored procedure (that resides within a Package) that takes a input parameter, from SQL*Plus?

thanks!
Tracy
Re: calling stored proc in a package [message #21038 is a reply to message #21036] Mon, 08 July 2002 09:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
exec PackageName.ProcedureName(INparameter1,....,INparamterN);

or

begin
PackageName.ProcedureName (INparameter1,....,INparamterN);
end;
Re: calling stored proc in a package [message #21052 is a reply to message #21036] Tue, 09 July 2002 07:25 Go to previous message
Tracy
Messages: 43
Registered: January 2000
Member
thanks. I should clarify that the stored procedure is returning a refcursor. So I seem to be missing something?
Previous Topic: urgent
Next Topic: please help me in these pl/sql !!
Goto Forum:
  


Current Time: Thu Mar 28 20:45:49 CDT 2024