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
amauri
Messages: 18
Registered: May 2013
Location: Italy
Junior Member
Hi,

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?

Example:

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

MAININSTALLSCRIPT.SQL
set define off
START FirstScript.sql &1
START SecondScript.sql &1
exit

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: 2544
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

Regards,
Lalit
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: Sun Dec 21 07:39:26 CST 2014

Total time taken to generate the page: 0.06237 seconds