SQL*Plus adding .SQL to arguments

From: chris webb <chrisj_webb_at_hotmail.com>
Date: Thu, 17 Jul 2003 21:35:59 +0000 (UTC)
Message-ID: <bf74rv$ler$1_at_sparta.btinternet.com>

I have an SQL script that runs another script with varying arguments. Something like:

_at__at_fred a b
_at__at_fred d e
_at__at_fred f g

...

Quite correctly, SQL*Plus adds ".SQL" to "fred" and runs my file "fred.SQL". But, it is also adding ".SQL" to the last argument. So when "fred" runs, its value of &2 is "b.SQL" not "b" for example. I have tried this on a number of servers, each running SQL*Plus 8.0.5.0.0 and it only happens on one server - the others are ok. I have tried SHOW ALL and can see no significant difference between the ones that work and the one that does not!

Anyone else seen this behaviour?

Thanks, Chris Received on Thu Jul 17 2003 - 23:35:59 CEST