RE: problem with '$' and Oracle

[Brian Sanders <bsanders@risklabs.com>]

Hmmm...the only thing I can see that is wrong is the missing equals sign on
the second line (where index_name = 'CGPR_C$').

-------------------------------------------------
Brian Sanders -- Java Developer -- Risk Labs, LLC
678-784-4614 voice, 678-784-4714 fax
 

-----Original Message-----
Subject: problem with '$' and Oracle


Hello,

I am sending the following query to an Oracle
database:

select price from mytablename 
where index_name 'CGPR_C$' 
and settlement_date =
to_date('01/12/2001','MM/DD/YYYY')

I am getting the following error:
java.sql.SQLException: Invalid column name

All the column names have been verified, and the query
runs in SQLPlus and TOAD.  When I take out the "$",
the query runs fine.  When I try to code the "$" in
unicode, I still get the error.

Any help?
Thanks,
Ashley