OCI - Named Tables -HELP

Hai folks,

I have to retrieve array of strings from PLSQL procedure to C++ thru OCI.

CREATE TYPE EMP_TYPE IS TABLE OF VARCHAR2(30); PROCEDURE EMP_LIST(emp OUT EMP_TYPE);

I have tried many steps but i am getting error like 'Missing parameters'.

Following are my psedo code, pls check the steps followed is correct.

#define DATA_TYPE EMP_TYPE
OCITable *pTable = NULL;
OCIType *record_tdo = NULL;

main()

• Initialise
• Logon
• Prepare statment status = OCITypeByName(m_envhp, m_errhp, m_svchp, (text *)0, 0, (text *) DATA_TYPE, strlen(DATA_TYPE),(text *)0,0,OCI_DURATION_SESSION, OCI_TYPEGET_ALL, &record_tdo);

  status = OCIBindByPos(m_stmthp, &bndp, m_errhp,1,                   
                      (dvoid *) 0, (sb4) 0, SQLT_NTY,
                      (dvoid *) 0, (ub2 *)0, (ub2 *)0,
                      (ub4) 0, (ub4 *) 0, (ub4) CI_DEFAULT); 

  status = OCIObjectNew(m_envhp, m_errhp, m_svchp,
           OCI_TYPECODE_TABLE,record_tdo, 0,OCI_DURATION_SESSION, FALSE,   
           (dvoid **) &pTable); 

  status = OCIBindObject(bndp, m_errhp,record_tdo,(dvoid **) &pTable, 
			(ub4 *) 0,(dvoid **)0, (ub4 *) 0); 
 

• Execute stament. Execute is not successfull for me.

Any help is appreaciated.
Regards
Ganesh Received on Sun Nov 07 2004 - 23:55:08 CST