Oracle enterprise stage

[krisna]

Below error we are getting when we run the job.


The provided insert statement did not prepare correctly;
please verify that your statement is correct;
statement: INSERT INTO STG.LDM_DWR_CPS_REJECTS (SOURCE_ID, EXTR_BTCH_ID, SUBJECT_AREA, JOB_NAME, ERROR_TXT, ERROR_DT_TIMSTM) VALUES ( :SOURCE_ID, :EXTR_BTCH_ID, :SUBJECT_AREA, :JOB_NAME, :ERROR_TXT, :ERROR_DT_TIMSTM).

Thanks in advance

[chulett]

please verify that your statement is correct;

Did you?

Also, did the stage generate this DML or is it user-defined?

[ray.wurlod]

I'm a bit surprised not to see mention of the ORCHESTRATE object in the VALUES clause.

[chulett]

... which leads me to believe it is the latter.

[krisna]

it's latter part got from director log.

[ray.wurlod]

So inspect the stage to let us know whether it's generated or user-defined SQL. We suspect it's the latter, and that whoever constructed the SQL did not know how to reference the ORCHESTRATE object in the VALUES clause.