Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> How to refer to an element of a col defined as varray of an object datatype
Hi I need help.
I have a column col_1 in a table tbl_A of varray names INSTRING WHICH inturn is defined of the an object type OSTRING, size 8.
OSTRING has 2 attributes
languageid of the type number(4,0)
and
string of the type varchar2(255).
from this table I want to compare string to an input parameter.
I was trying to reference it as follows:
where tbl_A.col_1.string = inputparam;
I get the error, it is thinking col_1 is a table.
then I tried using VALUE clause as follows:
where VALUE(tbl_A.col_1.string)= inputparam;
i also tried using DREF, WITHOUT SUCCESS.
iF ANYBODY CAN HELP, I'll really appreciate that.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue May 02 2000 - 00:00:00 CDT
![]() |
![]() |