Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning a Cursor from Store Procedure
Message
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00418578
Message ID:
00425989
Vues:
17
Thanks Tim. I'll take a look and see what I can come up with. Boy, sure was easy with SQL Server. Guess I got spoiled!

And I would absolutely need to be building from the ground up if I were using OO4O. None of my older apps would be able to support this <g>.

>Hi George!
>It is possible...
>Last time I tried it however I was unable to pass it back into a cursor...
>
>I tried to convert it from a RS to a cursor but the times were slower than just using a SQLEXEC statement....
>
>Maybe you can get it to work out for you...
>
>There are examples in many languages including VB here:
>http://govt.oracle.com/~tkyte/ResultSets/index.html
>
>OO40 is a nice solution. (You can mulitithread)
>Only problem is you will need to use Record Sets and bind all data fields to the record sets.
>It is very very simple to use...But I am not using it because the old code uses all cursor based style of coding and is non object oriented.
>If you are building up an application from scratch this is deffinately a good way to go...
>
>HTH
Everything we see or seems
Is but a dream within a dream
- Edgar Allen Poe
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform