Sv: Error message when using database link

From: Hans Henrik Krohn <hhk_at_tips.dk>
Date: 2000/04/25
Message-ID: <8e3n3s$ggp$1@news1.tele.dk>#1/1

Jim Burton <ocnjburt_at_admiral.umsl.edu> skrev i en nyhedsmeddelelse:8e1h4u$baq_at_news.umsl.edu...
> Oracle 7.3.4 on Sun OS 5.6. I have a database link. SQLPlus works on the
> client using the link. But I can't get SQLPlus to work with the link on
the
> server. Here is an example statement and the error messages I get. Anyone
have
> any idea?
>
>
> select * from sys_table_at_mydatabase
>
> ERROR at line 1:
> ORA-02248: invalid option for ALTER SESSION
> ORA-02063: preceding line from database
>
> Thank you

Hi Jim, I <_think_> this can be caused due to differences in the NLS-settings of the server and client - query V$NLS_PARAMETERS to see if there are any differences.

Regards,
Hans Henrik Krohn Received on Tue Apr 25 2000 - 00:00:00 CDT