sql*plus

From: <cpiodumpv_at_gmail.com>
Date: 13 Jan 2006 08:52:42 -0800
Message-ID: <1137171162.625002.192850@g14g2000cwa.googlegroups.com>

I have an sql script which I would like to perform an update with via a command line parameter:

update cps_parameters set parameter_data=&1

where	parameter_group_name='AR_LOAD_DEBUG_MODE'
and	parameter_key='MODE'

/

commit
/

this error is thrown when i execute the script. someguy_at_somedatabase> @set_debug_mode 'OFF' old 1: update cps_parameters set parameter_data=&1 new 1: update cps_parameters set parameter_data=OFF update cps_parameters set parameter_data=OFF

                                         *

ERROR at line 1:
ORA-00904: "OFF": invalid identifier

How can I fix this/accomplish this functionality.

Thank You. Received on Fri Jan 13 2006 - 10:52:42 CST