Re: The dollar symbol in SQL script names and Unix
- From: John Piwowar <jpiwowar@xxxxxxxxx>
- To: tony@xxxxxxxxxxxxxxx
- Date: Thu, 6 May 2010 16:06:04 -0400
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@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@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.
On Thu, May 6, 2010 at 3:06 PM, Tony Sequeira <tony@xxxxxxxxxxxxxxx> wrote:
> Michael Moore wrote:
>
> Maybe you could just create an alias / link .
>
> I've been attempting get a mutually acceptable work around, no success.
>
> I offered to create a wrapper script, no go.
>
> Just need to know if anyone has come across any issues, for my own peace of
> mind.
>
> On Thu, May 6, 2010 at 11:57 AM, Tony Sequeira <tony@xxxxxxxxxxxxxxx>wrote:
>
>> Hi all,
>>
>> Anyone have any issues with SQL script names in Unix (AIX specifically).
>>
>> This is in relation to S. Feuerstein's fine PL/SQL error handling library
>> Quest Error Manager:
>>
>>
>> http://www.toadworld.com/DOWNLOADS/Freeware/QuestErrorManagerFreeware/tabid/685/Default.aspx
>>
>> I've been told that the install script qem$install.sql, has caused, and
>> is liable to cause problems running in SQL*Plus (no here document involved
>> in this case, a simple sqlplus and @scriptname).
>>
>> First I've heard of it, anyone else?
>>
>> I'm home now, but I'll have a bash at it on a Solaris 10 machine tomorrow,
>> see if I can break it. ISTR recall that to use an environment variable in
>> SQL*Plus, you have to use a here document. I've had a quick google, nothing
>> has come to light.
>>
>> Thing is, I've been asked to change the script names, so that none of them
>> have a dollar symbol in them, never mind my protests.
>>
>> Regards.
>>
>> --
>> S. Anthony Sequeira
>> ++
>> Their idea of an offer you can't refuse is an offer... and you'd better
>> not refuse.
>> ++
>>
>>
>>
>
>
> --
> S. Anthony Sequeira
> ++
> Somewhere in Tenafly, New Jersey, a chiropractor is viewing "Leave it
> to Beaver"!
> ++
>
>
Other related posts:
