Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sqlplus argument with ÖÄÜöäü
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 - 10:52:08 CST
![]() |
![]() |