Error message: ORA-00911: invalid character.

neeraj · Post by **neeraj** » Wed Oct 15, 2014 9:04 am

Hello,

I have created a job design where I am passing the SQLStatement at run time. The SQL script file is kept at Unix.

The SQL statement is

select name,ID,DOJ from Table1
where Name <>\'Rahul\' and DOJ= TO_DATE(\'01/01/2009\', \'MM/DD/YYYY\')

My job is aborting with the below mentioned Director log

Source,1: The following SQL statement failed: select name,ID,DOJ from Table1 where Name <>'Rahul' and DOJ= TO_DATE('01/01/2009', 'MM/DD/YYYY').

Source,1: The OCI function OCIStmtExecute returned status -1. Error code: 911, Error message: ORA-00911: invalid character. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 3,092)

This query is running fine when I am execting it in Oracle.

Can you please let me know the solution of it.

Regards
Neeraj

Bostonian · Post by **Bostonian** » Wed Oct 15, 2014 5:15 pm

Instead of adding \ to the line break in the query, could you try to adding APT_OSL_PARAM_ESC_SQUOTE as a User Defined variable for your project or in the specific job parameter while setting its value to "\" without quotes ?