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

Home -> Community -> Usenet -> c.d.o.tools -> How to refer to an element of a col defined as varray of an object datatype

How to refer to an element of a col defined as varray of an object datatype

From: <kaushalg_at_my-deja.com>
Date: 2000/05/02
Message-ID: <8eng2j$uv0$1@nnrp1.deja.com>#1/1

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

Original text of this message

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