Re: sqlplus argument with ÖÄÜöäü

Thank you very much for your help. The script fail in the same way with or without double quotes. If I'm working in SQLPLUS everything is fine and if i call sqlplus with arguments I have the problem with the character over 127. I think there is a mistake in the LANG setting. Do you have any idea?

Karsten

Sybrand Bakker schrieb:

> 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 Mon Mar 12 2001 - 13:16:40 CST