Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_SQL (Oracle 10g)
DBMS_SQL [message #303915] Mon, 03 March 2008 05:08 Go to next message
ShridharV
Messages: 29
Registered: January 2008
Junior Member
Hi,

I need to write a procedure with refcursor as the out parameter(which contains the result set). Is it possible to write a procedure which has the refcursor as the out parameter and use DBMS_SQL for handling the bind variables? If so, please give me a sample example if possible.

Thanks in advance.
Re: DBMS_SQL [message #303924 is a reply to message #303915] Mon, 03 March 2008 05:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not before 11g.

Regards
Michel
Re: DBMS_SQL [message #303931 is a reply to message #303924] Mon, 03 March 2008 05:51 Go to previous messageGo to next message
ShridharV
Messages: 29
Registered: January 2008
Junior Member
Hi,

Thanks for the reply.
Cann you please tell how to accomplish in 11g?
Re: DBMS_SQL [message #303937 is a reply to message #303931] Mon, 03 March 2008 06:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can give a ref cursor as a parameter to dbms_sql.to_cursor_number and get a cursor number for a classical use of dbms_sql.

Regards
Michel
Previous Topic: Get data from Multiple Columns to one column
Next Topic: Converting from number to words
Goto Forum:
  


Current Time: Sat Dec 03 16:16:35 CST 2016

Total time taken to generate the page: 0.13286 seconds