Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calling stored procedure via MS ODBC
Message
De
21/07/2001 11:02:15
Gunawan Santoso
Pt. Japfa Comfeed Indonesia
Surabaya, Indonésie
 
 
À
21/07/2001 05:47:44
Information générale
Forum:
Oracle
Catégorie:
Autre
Divers
Thread ID:
00533450
Message ID:
00533519
Vues:
11
Pardon?
I've already used ref cursor, please see my previous example. It works with Oracle's ODBC not with MS. I really want to see the thread you mentioned, but I don't have such access (or I don't know how?).

Actually I have found the MS KB article Q221189 - HOWTO: Retrieve a Resultset from Oracle Stored Procedures. I tried it, and I've got it working. But it's more complicated since I have to use Table type in packages parameter to send out the resultset. This is what MS says about it:

Proc_String1 = "{call FoxPackage.Proc1({resultset 3, o_id , " + ;
"ao_course, ao_dept})}"


If you have a sample code, would you mind post it here?

Regards,
Gunawan Santoso
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform