Insert into table fails Using XSJS

[former_member184867]

Hello Experts,

I am using following code to to insert data in an table. But this gives error. 

var conn = $.db.getConnection();  
var pstmt = conn.prepareStatement('insert into \"SCHEMANAME.TABLENAME\" values(\'XXX\',\'20121006\',\'185712\', 12.0)');  
var rs = pstmt.execute(); 

Same insert statement works fine from SQL console.

Question1: How can I fix this error?

Question2: How can I capture the exception ?

Please help.

Regards,

Atanu

[former_member329609]

Hello Atanu,

Just before the date constant in the query, can you please insert "TO_DATE" ?

Thanks,

Veera

[former_member329609]

Or please try to use VALUES(?,?,?,?) followed by SET() to avoid SQL injection.

[former_member184867]

I am using the following table