passing parameters to sql (i'm puzzeled)

From: rob <rob_at_dsdelft.nl>
Date: Tue, 8 Oct 2002 17:22:36 +0200
Message-ID: <anut7t$qea$1_at_news.tudelft.nl>

I've encountered the following problem. On one client the delimiter for passing parameters is double-quote and on the other (Dutch W2000) it has to be a single-qoute. Does anyone have an idee what setting is responsible for this behaviour?

I have two W2000 clients oracle 8.1.7.
One is a Dutch version.
I have a sql script test.sql

select '&1'


,      '&2'

,      '&3'

from dual;

On US Windows:
c:\sqlplus un/pw _at_test.sql "1" "2 2" "3"

old   1: select '&1'
new   1: select '1'
old   2: ,'&2'
new   2: ,'1 2'
old   3: ,'&3'
new   3: ,'3'

' '12 '
- --- -
1 1 2 3

On Dutch Windows:
c:\sqlplus un/pw _at_test.sql "1" "2 2" "3" oud 1: select '&1'
nieuw 1: select '1'
oud 2: ,'&2'
nieuw 2: ,'2'
oud 3: ,'&3'
nieuw 3: ,'2'

' ' '
- - -
1 2 2

Regards,
Rob Received on Tue Oct 08 2002 - 17:22:36 CEST