Home » SQL & PL/SQL » Client Tools » & and SET DEFINE OFF (Oracle 10g)
& and SET DEFINE OFF [message #600959] Thu, 14 November 2013 04:14 Go to next message
Messages: 18
Registered: May 2013
Location: Italy
Junior Member

I have a main batch file that calls a main SQL script passing it a parameter.
The Main SQL script then calls several small scripts passing the received parameter as &1.
Can I use SET DEFINE OFF in my Main SQL script, or am I to move it to the scripts being called?


SQLPLUS %1/%2@%3 @MainInstallScript.sql %4

set define off
START FirstScript.sql &1
START SecondScript.sql &1

Re: & and SET DEFINE OFF [message #601007 is a reply to message #600959] Thu, 14 November 2013 08:22 Go to previous message
Lalit Kumar B
Messages: 3106
Registered: May 2013
Location: World Wide on the Web
Senior Member
You would need to substitute the '&' character with some other character or disable the macro preprocessing. T.Kyte has provided a solution here

Previous Topic: Oracle + Crystal Reports on Windows 7 64 Bit Machine
Next Topic: SQL developer hangs on Win XP if not admin
Goto Forum:

Current Time: Sat Oct 10 06:46:09 CDT 2015

Total time taken to generate the page: 0.08230 seconds