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