Re: sqlplus argument with ÖÄÜöäü

Hi Karsten,

this is not an Oracle problem but a shell problem.

Normal shells don't accept anything with eight bits. Please check the settings of your (virtual) tty by "stty < /dev/...", where "/dev/..." is the tty mentioned by "who am i".

Martin

karsten wrote:
>
> Hi,
>
> i would like to call sqlplus with 2 arguments on sun solaris 2.6. The
> Database is created with characterset WE8ISO8859P1.
>
> #!/bin/ksh
> p1=MÄRZ
> p2=APRIL
> sqlplus system/feivel @y.sql $p1 $p2
> echo $p1
> echo $p2
> echo $NLS_LANG
>
> Result:
> SQL*Plus: Release 8.0.4.0.0 - Production on So Mär 11 17:29:26 2001
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
> Connected to:
> Oracle8 Enterprise Edition Release 8.0.4.3.0 - Production
> PL/SQL Release 8.0.4.3.0 - Production
>
> old 1: select '&1', '&2' from dual
> new 1: select 'M', 'RZ' from dual
>
> ' 'R
> - --
> M RZ
>
> Disconnected from Oracle8 Enterprise Edition Release 8.0.4.3.0 -
> Production
> PL/SQL Release 8.0.4.3.0 - Production
> MÄRZ
> APRIL
> german_germany.WE8ISO8859P1
>
> I accepted MÄRZ and APRIL in sqlplus, but it fails. Has anybody an idea
> how to solve my problem
>
> Thank in advanced
>
> Karsten
Received on Sat Mar 17 2001 - 07:23:29 CST