while updating in oracle table fatal error

prams · Post by **prams** » Wed Jul 16, 2008 4:27 am

Hi All

i have a requirement like status_id need to update if as_of_date is already exits in the the table.

For this i am taking the as of date from source and loopup with target table with lookup stage and then if already that date exits then i am passing the status value for update query in oracle.

the fatal error like this below

main_program: Fatal Error: Destination "inputData.STATUS_ID" is already bound.

Thanks
prams

mahadev.v · Post by **mahadev.v** » Wed Jul 16, 2008 5:32 am

Are you changing the metadata of the field "inputData.STATUS_ID" in the job with the RCP on? If yes switch off RCP in the stage where you have modified the field and run the job.

keshav0307 · Post by **keshav0307** » Wed Jul 16, 2008 6:02 am

probably because the lookup reference source and target is same.

the lookup type is normal or sparse?

try sparse lookup