I am reading an file containing SQL statements and
when the jdbc driver execs the following
statement:
UPDATE system_code_description SET
description = '$' where [omitted]
it generates an error indicating that it cannout
update the column description to null.
Turning debugging on, I noticed that the '$' is
removed when the jdbc executes, so
the resulting statement is:
UPDATE system_code_description SET
description = '' where [omitted]
I assume the SQL task is removing the $ when
attempting replace properties within an ant file.
Is there a way to turn off this pre-processing of the
file? If I make the value '$$', then
the SQL statement executes correctly.
These files are also to be executed from a tool like
'sqlplus' so I cannot
simply add another $ or I will get undesirable
effects.
Any suggestions. Is this a bug?
Using oracle 1.1.1 jdbc driver (classes111.zip).
Ralph Bohnet
EFA Software Inc.
__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
