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: 65155
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: Oracle query error
Goto Forum:

Current Time: Wed Aug 23 16:37:12 CDT 2017

Total time taken to generate the page: 0.01411 seconds