test procedure [message #37875] |
Mon, 04 March 2002 15:01 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
Hi,
how to test a stored procedure
i have a procedure with a cursor
procedure (c1 IN OUT cursor, empid IN number, deptid IN number)
iam opening c1 cursor and selecting few attributes from the table.
if i test the procedure its give message successfully completed.
Iam trying to print the values from the cursor i opened
does any one know how to do it.
Thanks
sam
|
|
|
Re: test procedure [message #37876 is a reply to message #37875] |
Mon, 04 March 2002 17:17 |
seng
Messages: 191 Registered: February 2002
|
Senior Member |
|
|
Use this package in your procedure DBMS_OUTPUT.PUT_LINE('') to get the output. e.g sample
create procedure test is
debug varchar(1);
begin
if debug ='Y" then
dbms_output.put_line(CharVaraible);
end;
In SQLPLUS, you need to SET SERVEROUTPUT ON; you will have output if you execute this procedure.
sqlplusexecute test;
Hope this is helping you. thanks
|
|
|