sqlplus argument with ÖÄÜöäü

Hi,

[Quoted] 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 _at_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 - 17:52:08 CET