how to make insert or update when using OCI stage in intarge

vardhan354 · Post by **vardhan354** » Tue Sep 19, 2006 5:27 pm

Hi ,

i am using userdefined SQL for the UPDATE ACTION, the function of the
userdefined sql is it inserts the data into the table, i am adding more columns to the existing job, i mean it is a new column as per the business requirement, here i need to use update action as insert (or) update.

give me an information what is the best way to follow.

if i change the sql insert or update then it will work.

Please give me idea.

Thanks in advance.

meena · Post by **meena** » Tue Sep 19, 2006 6:04 pm

Hi Vsi,

It depends on your specfications.If you want update the existing rows then you can use update or insert (as you have to insert new rows). Else use only insert option.

kumar_s · Post by **kumar_s** » Tue Sep 19, 2006 7:34 pm

If you are editing the exisitng column, you need to edit the existing user defiled code as well.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 12:49 am

"user defined", surely?