Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Hostarrays and UPDATE with missing records
Hi,
i'm in the process of optimizing some of our Oracle applications, but have run into a tricky situation.
I have some code like this:
UPDATE record
IF UPDATE failed
INSERT record
END IF
Can i achieve the same result using host arrays? I would like to try to
UPDATE e.g. 100 records at a time, and have an indicator of which
failed, and then INSERT those. I don't see anything about this in the
manuals, so i guess it is not possible.
Any other solutions than issuing the above code one time per record?
Best regards,
Brian
Brian Rasmusson, Software engineer & analyst e-mail: br_at_belle.dk Belle Systems A/S web : www.belle.dk Network, Internet and communication specialists phone : +45 59442500Received on Mon Mar 02 1998 - 00:00:00 CST
------------------------------------------------------------------------