| & and SET DEFINE OFF [message #600959] |
Thu, 14 November 2013 04:14  |
 |
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  |
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
Regards,
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
