Page 1 of 1
Deleting record from Oracle table
Posted: Wed Oct 15, 2008 6:24 pm
by das_nirmalya
When i am trying to delete record from a table in Oracle enterprise stage select Write Method : Delete rows .
It is giving error :Unable to use a record for update.
Please sugest.
Posted: Wed Oct 15, 2008 7:25 pm
by chulett
![Confused :?](./images/smilies/icon_confused.gif)
Suggestion: Post the
actual, unedited, full error. Is it a DataStage message or one from Oracle?
Posted: Wed Oct 15, 2008 7:31 pm
by das_nirmalya
chulett wrote:![Confused :?](./images/smilies/icon_confused.gif)
Suggestion: Post the
actual, unedited, full error. Is it a DataStage message or one from Oracle? ...
F_JDE_FACT,1: Unable to use a record for update.
This is a DataStage message.
Posted: Wed Oct 15, 2008 7:46 pm
by ray.wurlod
And was any record in fact provided to the stage on node #1? If you only provided one record in your design, then it was unwise to run that stage on more than one node.
Posted: Fri Jun 18, 2010 2:00 pm
by Neerav
If you are trying to delete record and have a child depenedency you will get the message "unable to use a record for update" in oracle enterprise stage
Posted: Fri Jun 18, 2010 2:31 pm
by nagarjuna
These type of errors you will face incase you are trying to update a nonexistant record