Re: sqlplus argument with ÖÄÜöäü

"karsten" <karsten_thiele_muc_at_yahoo.de> a écrit dans le 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
>
>

Did you try double-quoting your parameters?

sqlplus system/feivel @y.sql "$p1" "$p2"

--
Hope this helps
Michel