Re: sql*plus

From: <fitzjarrell_at_cox.net>
Date: 13 Jan 2006 08:55:51 -0800
Message-ID: <1137171351.662327.200170@g44g2000cwa.googlegroups.com>

cpiodu..._at_gmail.com wrote:
> 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.

The answer is obvious:

 update cps_parameters set parameter_data='&1'

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

 /
 commit
 /

David Fitzjarrell Received on Fri Jan 13 2006 - 10:55:51 CST