execute procedure syntax [message #866] |
Sat, 09 March 2002 23:49 |
Renu
Messages: 7 Registered: February 2002
|
Junior Member |
|
|
hi,
I have a problem in executing Oracle Stored Procedure.
The procedure has 2 input parameters and one output parameter.
Could u pl tell me the syntax of executing this type of procedure.
I know its like--Execute procname('inputparam1','inputParam2',
How do i specify the output parameter?
How do i access the resultset ?Pl help
|
|
|
Re: execute procedure syntax [message #870 is a reply to message #866] |
Sun, 10 March 2002 15:32 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
declare a variable to keep the output parameter.
e.g
declare
var1 varchar2;
begin
var1=procname('inputparam1','inputParam2');
DBMS_OUTPUT.PRINT(var1); -- var 1must be var char
end;
in SQLPLUS,please set SERVEROUTPUT ON;
Hope this is helping.
|
|
|