Problem: nested table of references
From: myName <myName_at_myCompany.com>
Date: 1998/01/13
Message-ID: <34BBF9BB.6BA3_at_myCompany.com>#1/1
);
Date: 1998/01/13
Message-ID: <34BBF9BB.6BA3_at_myCompany.com>#1/1
The schema looks like this:
create type val as object(
some_text varchar(200)
);
create type valTab as table of ref val;
create type logRec as object(
id number(10), logDate date, vals valTab
);
create table valTable of val;
create table logRecTable of logRec
nested table vals store as nt_vals;
I have not been able to read some_text using SQL nor using OCI:
select deref(t) from the (select vals from logRecTable where id = 1) t
*
and trying to access the reference via OCIIter results in an invalid
val_ref.
The interesting thing is, that counting the # of references works
perfect, but I can't use them!
Christian
ORA-00904: invalid column name
-- Christian Schaarschmidt Siemens Corporate Research schaarsc_at_scr.siemens.comReceived on Tue Jan 13 1998 - 00:00:00 CET