How do i retrieve values from Varray.<BR>Plz Help me out !!!<BR>The design of the table is <BR><BR>create type prop as object<BR>(<BR>properties varchar2(4)<BR>);<BR><BR>create type proplist as VARRAY(20) of prop;<BR><BR>create table tbl_product_charateristics (<BR>prd_code varchar(4) not null,<BR>prd_properties proplist<BR>)<BR><BR>How to retrieve the values of properties?
Dear atrax,<BR> This is the syntax for creating varrays in oracle.<BR>Now the problem is how to retrieve these values in my asp page.<BR>I'm able to insert values into this Varray and also<BR>I'm able to retreive values from other tables except this one.<BR>All the tables are in oracle database. <BR><BR>
I wish you'd given us this information in the first place.<BR><BR>no, I don't think you can directly pull VARRAYS from oracle, unless you can convert them into a format like maybe a recordset.
ADO its much simpler just to return a cursor with your values. Then you access it in your normal old recordset like any other database.<BR><BR>Are you using Oracle packages? If yes, write your yourself a nice procedure that returns a cursor as an input/output parameter. You might even try populating the cursor with the values from your existing tbale and that varray.<BR><BR>Play around with this one a little. ; )