|Complex Recordsets - Build complex recordsets using temporary or PL/SQL tables within stored procedures.|
Grek said...Great article, it really helped... Thanks a million!
Pravin said...Good article.
Deepak Barwa said...This article has been very helpful for me
I had been searching this solution for last 5 days...
Debojyoty said...Excellent Information!!!
I was wondering if it works in oracle 9i and oracge 10g
Tim... said...It works fine.
JP said...What is the complete connection string? You're using a DSN but I don't see anything that tells me what driver the DSN is using.
Tim... said...The example uses a system DSN, so the driver is defined in the DSN itself, so this is the full connection string.
I usually use the Oracle ODBC drivers, so I guess this is what I used then, but it was a long time ago.
Wolverine said...Brotha ya rock,
Keep it rolling,
how about creating a scaling version of knowledge,,,one for beginners ,
then for players,
and then one for masters.....
you rock....thanx for tithing...God bless ya
Tim... said...That's a good idea, but unfortunately, it would require alot more time. If this were my job I would certainly consider it, but as it's just something I do in my spare time I'm not sure I'll get round to it :)
vishal tatwade said...very good article it solved my problem .
great guys job done like this is very nice.
Dimasik said...Thank you very much!
It is a great topic, you`ve helped me very much :)
Dimasik said...But I hate VB, by the way...)
vel said...Hai friend...
I AM VERY INTEREST TO LEARN IN ORACLE 9I & ALSO ORACLE BASIC COMMANDS
Rob said...Hi that's a lovely piece of code. However it leaves the cursor open on the database .... is there a way to open, fetch and then close this ?
You can't close the cursor. You are opening it in a procedure, using a ref cursor, so you can pass it out to another program. You must leave the cursor open, the application it is passed to closes it when it has finished with it. If you closed it, you would be passing an invalid cursor to your application and it wouldn't be able to do anything with it.
I think you may have understood the purpose of this code.
PS. Questions in the forum, not in the comments please.
Tom said...Tim, you are God sent....this just helped me save my job...
ACM said...Great, just what I was looking for.