Forums | Aggregator | Books | Industry News | Firefox Plugins | Social | Links

Comments

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.

Cheers

Tim...

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.

Cheers

Tim...

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 :)

Cheers

Tim...

vishal tatwade said...

very good article it solved my problem .

great guys job done like this is very nice.


vishal

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 ?
Thanks

Tim... said...

Hi.

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.

Cheers

Tim...

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.

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

Add your comments here.
Name
Comment
(max 400 chars - plain text)