How to display a cursor variable in proc ?

[moin73]

My cursor is returning a value, how to display it with dbms_output.put_line command.

I m getting followng error msgs ORA-24338

dbms_output.put_line(to_char(o_result_set_rc));

 

[sem]

You can not print cursor with
dbms_output.put_line. If you're in sql*plus, you may define REFCURSOR variable and then just print it. Otherwise you should loop through your cursor manually.

Regards, Dima

http://seminihin.narod.ru

 

[moin73]

I am trying and getting following error msgs.

ERROR:
ORA-24338: statement handle not executed


SP2-0625: Error printing variable "myrefc

 

[sem]

Is that variable empty? Have you indeed opened any statement for it or just declared it and tried to print?

Regards, Dima

http://seminihin.narod.ru

 

[moin73]

It's resolved, appreciate your help.

Thanks

 

[lewisp]

Care to share the solution?