Where do you execute this script? In sql*plus you can use "set define off" to disable parameter passing to sql.
Joined: Jun 11, 2008
Thanks Faith for your quick response.
I am executing the script in sqlplus and I tried your suggestion and its working excellent.
I have one more question, do I have to unset this (set define off) or automatically get unset after my sqlplus session closed?
Joined: Sep 01, 2005
You are welcome,
You can use "set define on" to enable parameter passing in the same session, but you are right it is effective during your own session.
Each time you create a new session you have to set/unset it.