Home » Other » 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: 3174
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: Tue Sep 26 09:47:32 CDT 2023