Re: Regarding Database links

Prem,

You don't indicate the version of the remote database, but the ORA-3115 error indicates a networking incompatibility, although it's possible that it could be symptomatic of another error. I did a quick search of the docs and was unable to find anything indicating that nested tables can't be queried via dblinks.

I'm assuming that your query is correct (i.e. if you connect directly to the dcom db, that you can successfully issue select comp_code from str_roster;).

You're probably going to need to log a tar with Oracle Support so they can assist you in generating sql and/or net tracing and interpreting it.

HTH,

• Anita
  • prem_at_ibsplc.com wrote:
    > The link is created in the Oracle database version
    > 8.0.4.0
    >
    > I created a DB link using the command
    >
    > create database link 'linkname' connect to 'user'
    > identified by 'password'
    > using 'name';
    >
    >
    > Now when I try to access the data using the DB Link,
    > it is not possible if
    > it is contains a nested table
    >
    > The error that I am getting is
    >
    > SQL> select comp_code from str_roster_at_dcom;
    > select comp_code from str_roster_at_dcom
    > *
    > ERROR at line 1:
    > ORA-03115: unsupported network datatype or
    > representation
    > ORA-02063: preceding line from DCOM
    >
    >
    > Above shown is the select statement and the error
    > got on trying to access.
    >
    >
    > Regards
    > Prem
    >
    >
    >
    >
    >
    >
    > "A. Bardeen" <abardeen1_at_yahoo.com> on 07/04/2000
    > 01:42:42 PM
    >
    > To: ORACLE-L_at_fatcity.com, PremChandran N/IBS
    > cc:
    > Subject: Re: Regarding Database links
    >
    >
    >
    >
    > Prem,
    > You'll get a much better response if you provide
    > more
    > details:
    > What are the versions of the db's?
    > What are the errors you're getting?
    > What's the syntax of your command?
    > HTH,
    > -- Anita
    > P.S. Keep in mind this is a long holiday weekend
    > (July 4th holiday) in the US, which is why the list
    > traffic is so much smaller.
    > --- prem_at_ibsplc.com wrote:
    > > No one has yet replied to my problem regarding the
    > > Database links. The
    > > problem is that I can't access Nested tables usign
    > > the DB link. Can anyone
    > > give me a solution to this
    > >
    > > Regards
    > > Prem
    > >
    > >
    > > --
    > > Author:
    > > INET: prem_at_ibsplc.com
    > >
    > > Fat City Network Services -- (858) 538-5051
    > FAX:
    > > (858) 538-5051
    > > San Diego, California -- Public Internet
    > > access / Mailing Lists
    > >
    >

    ---

    
    > > To REMOVE yourself from this mailing list, send an
    > > E-Mail message
    > > to: ListGuru_at_fatcity.com (note EXACT spelling of
    > > 'ListGuru') and in
    > > the message BODY, include a line containing: UNSUB
    > > ORACLE-L
    > > (or the name of mailing list you want to be
    > removed
    > > from). You may
    > > also send the HELP command for other information
    > > (like subscribing).
    >
    > __________________________________________________
    > Do You Yahoo!?
    > Kick off your party with Yahoo! Invites.
    > http://invites.yahoo.com/
    >
    >
    >
    >
    

    ---