The dollar symbol in SQL script names and Unix

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Thu, 06 May 2010 19:57:57 +0100
Message-ID: <4BE31135.1050406_at_sequeira.org.uk>



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 _at_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.
++
-- http://www.freelists.org/webpage/oracle-l
Received on Thu May 06 2010 - 13:57:57 CDT

Original text of this message