Re: "unsupported network datatype or representation" when accessing a synonym

ppn_at_mederic.fr (PPN) wrote in message news:<6f6a7f59.0304070042.4f6b5a78_at_posting.google.com>...
> Hello,
>
> I'm facing a weird problem. I have to add a filter over a date column
> to retrieve only valid records. I am selecting from a table that is a
> synonym. The database I am connected to is Oracle 8i, whereas the
> database containing the synonym is Oracle 7.3.4.5.0.
> Whenever I try to access a table in Oracle 8i using a filter on a date
> column, it works. But when I try to access a table by synonym (thus a
> table in Oracle 7) filtering on a date column, I get this error :
> "ORA-03115: unsupported network datatype or representation
> ORA-02063: preceding line from DBJOE".
>
> I have activated JDBC 2 behavior for the driver.
>
> Would anyone know what could be going on ?

Be sure the dblink login has been granted access to the synonym, check the session and db environment settings for dates (ie, select * from nls_session_parameters where parameter='NLS_DATE_FORMAT'; on both machines - default changed at 8.1.6), check for OOB settings in the sqlnet.ora if you are going between hp and sun, check the global_names parameters, and see if the code works directly on the 7 db. Then post the code you are using. If you can't do it directly on the 7 db, you'll probably have to do some weird workaround.

jg

--
@home.com is bogus.
Using a state of the art purification system, we have created a
consistent taste and purity.