basically, i have a string which will serve as sql statements to insert something into oracle.... below is the println of the (dynamically) generated statement:
INSERT INTO transacteditems VALUES (orderid.currval, bought(song(24, 'ADDICTED', 'SIMPLE PLAN', '10 SEPTEMBER 2003', '0.50', 'N', 'ALT', 'images/SP.JPG')))
calling the method from jsp, i would get an exception:
Message: java.sql.SQLException: ORA-00911: invalid character
however, when i copied the code to run in oracle's sqlplus, it worked fine....
any ideas anyone?? thanks a lot!!