Re: sqlplus argument with ÖÄÜöäü

Try
- to avoid unnecessary crossposting to all Oracle groups (your not necessarily getting a bigger audience) - to embed your string arguments in double quotes

Hth,

Sybrand Bakker, Oracle DBA

"karsten" <karsten_thiele_muc_at_yahoo.de> wrote in message news:3AABAD38.7EFB1E88_at_yahoo.de...
> 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 Sun Mar 11 2001 - 15:20:29 CST