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
Oracle enterprise stage
Moderators: chulett, rschirm, roy
Re: Oracle enterprise stage
Did you?krisna wrote:please verify that your statement is correct;
Also, did the stage generate this DML or is it user-defined?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I'm a bit surprised not to see mention of the ORCHESTRATE object in the VALUES clause.
Last edited by ray.wurlod on Sun Oct 30, 2011 2:41 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.