Deleting record from Oracle table

das_nirmalya · Post by **das_nirmalya** » Wed Oct 15, 2008 6:24 pm

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.

chulett · Post by **chulett** » Wed Oct 15, 2008 7:25 pm

Suggestion: Post the actual, unedited, full error. Is it a DataStage message or one from Oracle?

das_nirmalya · Post by **das_nirmalya** » Wed Oct 15, 2008 7:31 pm

chulett wrote: 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.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 15, 2008 7:46 pm

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.

Neerav · Post by **Neerav** » Fri Jun 18, 2010 2:00 pm

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

nagarjuna · Post by **nagarjuna** » Fri Jun 18, 2010 2:31 pm

These type of errors you will face incase you are trying to update a nonexistant record