Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> collection of primitive type

collection of primitive type

From: <vchepkov_at_gmail.com>
Date: 29 Nov 2005 07:50:27 -0800
Message-ID: <1133279427.944185.92860@o13g2000cwo.googlegroups.com>


All,

I have read all examples how to access an object in a collection, but I am out of luck trying to get access to a primitive type in the collection. Would anybody help me, please. That what I have:

trange.sql:



create type trange as table of char(8);
/

create function intervals(n in pls_integer) return trange is ...
/

trange.h: (generated by ott)



typedef OCITable trange;

trange.pc: (fragments)



trange* interval_list = (trange*)0;
text str[8];
EXEC SQL ALLOCATE :interval_list;
EXEC SQL CALL intervals(:n) INTO :interval_list;
/* I know that function call works fine, since I can examine the size
of the returned collection */
EXEC SQL COLLECTION GET :interval_list INTO :str ;

Nothing in str :(. I tried to use pointer instead, same result. I am missing probably something obvious, but can't find what it is .

Thank you,
Vadym Received on Tue Nov 29 2005 - 09:50:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US