Home » SQL & PL/SQL » SQL & PL/SQL » Need a little help in deriving the logic (Oracle
Need a little help in deriving the logic [message #573573] Mon, 31 December 2012 06:27 Go to next message
Messages: 49
Registered: April 2012
Hi All,

I have a problem at hand.
I have many valid sql statements in a file.
when my procedure runs i want to pick them one by one and execute it but i dont know what they will return nor do i know the queries.

Hence i am thinking of using ref cursor but how do i know the return type ?
Basically the into record type is what i want.
Please help

Thanks and Regards,
Re: Need a little help in deriving the logic [message #573576 is a reply to message #573573] Mon, 31 December 2012 06:42 Go to previous message
Michel Cadot
Messages: 62206
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
To know how to handle any SQL, have a look at T.Kyte's print_table function.

Previous Topic: How to convert a string into numeric other than to_number
Next Topic: REGEXP
Goto Forum:

Current Time: Wed Nov 25 19:14:02 CST 2015

Total time taken to generate the page: 0.04836 seconds