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
Error message: ORA-00911: invalid character.
Moderators: chulett, rschirm, roy