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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement