The dollar symbol in SQL script names and Unix

From: Tony Sequeira <>
Date: Thu, 06 May 2010 19:57:57 +0100
Message-ID: <>

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:

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.


S. Anthony Sequeira

Their idea of an offer you can't refuse is an offer... and you'd better not refuse.
Received on Thu May 06 2010 - 13:57:57 CDT

Original text of this message