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

Home -> Community -> Usenet -> c.d.o.misc -> Access user-defined type column remotely

Access user-defined type column remotely

From: cschang <cschang_at_maxinter.net>
Date: Mon, 24 May 2004 18:04:24 -0400
Message-ID: <40B27168.40609@maxinter.net>


I have two separate databases schema (local, remote) location at different machines. One of the tables on the remote schema is constructed with a user-defined column such as

create or replace type a_t as object
( a varchar2(1),

    b number(5,2)
);

create or replace type a_nt as table of a_t
/

create table my_tbl
(

     c    varchar2(2),
     d    a_nt,

    primary key ( c) using index tablespace i_index ) ..
nested table a_nt store my_tbl_tab..
/

How can I, from schema of here, access the detail info b in column of d of the my_tbl on schema remote? My system is 8.1.6 on NT 4. I have created a remote database link from the schema here to remote.

I have found some papers mentioning this subject on Asktom, but it limits the non-user-defined column? Because it defined a rowtype type of the remote table, however it cannot be used on the table containing object type. Received on Mon May 24 2004 - 17:04:24 CDT

Original text of this message

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