Re: The dollar symbol in SQL script names and Unix

From: John Piwowar <jpiwowar_at_gmail.com>
Date: Thu, 6 May 2010 16:35:12 -0400
Message-Id: <06507DD5-3669-40B4-991F-56C9D9D8D3AA_at_gmail.com>

Whoops, incomplete copy and paste! I'm AFK now, but when I tried to run the script from within SQL*Plus, I got the same "unable to open file" message.

Regards,

John P.

(Strange spelling? iPhone's fault. Strange content? Alas, that's all me)

On May 6, 2010, at 4:18 PM, "S. Anthony Sequeira" <tony_at_sequeira.org.uk> wrote:

> On 06/05/10 21:06, John Piwowar wrote:
>>
>> Hi Tony,
>>
>> In the bash shell, at least, it looks like the $ is interpolated if
>> not escaped, and confusing to SQL*Plus even if it is escaped.
>> Granted, this might be a peculiarity of the OS X SQL*Plus client.
>>
>> zathras:SQL jpiwowar$ sqlplus jpiwowar_at_MACTEST @te$t.sql
>>
>> SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:36 2010
>> <header trimmed>
>> SP2-0310: unable to open file "te.sql"
>>
>> zathras:SQL jpiwowar$ sqlplus jpiwowar_at_MACTEST @te\$t.sql
>>
>> SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 6 16:00:48 2010
>> <snip-snip>
>> SP2-0310: unable to open file "te$t.sql"
>>
>>
>> Regards,
>>
>> John P.
>>
>>
> Hi John,
>
> Thanks for the reply.
>
> Yes, if it's run on the command line, I can quite understand it. It
> will happen with any Unix OS AFAIK.
>
> But if it's run from within SQL*Plus?
>
> Regards
> --
> Tony

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 06 2010 - 15:35:12 CDT