OraFAQ Forum: Precompilers, OCI & OCCI » Retrieve collection of user-defined object in OCCI

Home » Developer & Programmer » Precompilers, OCI & OCCI » Retrieve collection of user-defined object in OCCI

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Retrieve collection of user-defined object in OCCI [message #93943]

Fri, 09 May 2003 19:12

Edward
Messages: 6
Registered: October 2000

Junior Member

Hi, there

I am having a OCCI problem, see if you guys can help me.

I try to retrieve a collection of user-define objects.

The major steps I am using are
1. define database object

CREATE OR REPLACE TYPE my_obj_t AS OBJECT
( id number, name varchar2(10) )

CREATE OR REPLACE
TYPE my_obj_tab_t as table of my_obj_t;

2. A stored procedure return a collection as out paramerter

my_stored_procedure(obj_list out my_obj_tab_t);

3. Using OTT to generate the *.cpp and header files.

4. Register out parameter like

vector<my_obj_t> vect;

stmt->registerOutParam(1, OCCIVECTOR,
sizeof (vect),
"MY_OBJ_TAB_T");

5. stmt->execute();

6. Try to get the results by
getVector(stmt, 1, vect);

I am getting compilation error:

Could not find a match for
oracle::occi::getVector(oracle::occi::Statement*,
int, std::vector<my_obj_t, std::allocator<my_obj_t>>).

Am I doing the right things ?
What steps and function should I use ?

Thanks in advance.

Edward

Report message to a moderator