Re: How to call an Oracle8i stored procedure that has Table Of data type in VB6?

Thanks Daniel for taking the time to read my post.

Here is a snippet of one of the stored proc that I have to call.

TYPE tconsent_scope IS TABLE OF T_SEC_CONSENT_SCOPE.CONSENT_SCOPE%TYPE INDEX BY BINARY_INTEGER;
TYPE tDATE IS TABLE OF DATE INDEX BY BINARY_INTEGER; TYPE tNUMBER IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; TYPE tCHAR IS TABLE OF CHAR(1) INDEX BY BINARY_INTEGER; TYPE tCONSENT_ID IS TABLE OF T_SEC_PATIENT_CONSENTS.CONSENT_ID%TYPE INDEX BY BINARY_INTEGER; PROCEDURE Register_Consent_List (v_Logged_On_User IN VARCHAR2,

     v_Ramq_ID IN VARCHAR2,
     v_Birthdate IN VARCHAR2,
     V_Consent_Signed_By IN VARCHAR2,
     V_Grantee_Id IN VARCHAR2,
     V_Consent_Scope IN tConsent_Scope,
     v_Starting_Date IN tDATE,
     v_Duration IN tNUMBER,
     v_Duration_type IN tCHAR,
     v_Confirmation_Num IN OUT tCONSENT_ID)

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DD3CD9C.61050BCF_at_exesolutions.com...
> Steve wrote:
>
> > Hi everyone,
> >
> > I need to call an Oracle8i (Oracle8i Release 8.1.7.4.1) stored procedure
> > that has a Table Of data type as an input parameter (possibly even
several
> > Table Of input parameters). I can't seem to find any example of how to
do
> > this in VB6 using ODBC (ADO 2.5 SP2). Is this even possible?
> >
> > Thanks!
>
> What do you mean by "table of data type as an input parameter"?
>
> An array being passed from the front-end? It is not clear.
>
> Daniel Morgan
>
Received on Thu Nov 14 2002 - 10:43:19 CST