[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com