You are not logged in.
we have a set of jobs which are running with oracle 10.
all have been working for a while.
we now switch to a new vendor's oracle database.
once switched, those jobs failed. oracle connection has no problem
but it seems that new oracle can't receive sql statement properly.
we keep getting ORA-xxxx errors across different jobs.
for example tOracleOutput, we can get this
ORA-00926: missing VALUES keyword
how should we look into this kind issue?
Yes, there is some syntax error in the SQL statement, see ora-00926, open the code tab and show us the SQL statement.