Do you insert your files as BLOB or what?
i can answer but I need it to know 'cause you can call function which will
return
OCILobLocator for EMPTY_BLOB and your index.
Using OCILobWrite you can insert your BLOB and if it falls you know index of
bad row.
I can send example of such procedure described above if you decide that such
way
acceptable for you.
Good luck.
Vladimir.
Hope it will help.
Yacov Wolfowicz wrote in message <36ED25E4.58207882_at_rose.ecitele.com>...
>Hi,
>Here is my problem:
>My input is several files. I need to read it, create db records and
>insert them to a certain table in the database. I'm using OCI, inserting
>the records in arrays of 200 or so and getting very good performance. So
>far, so good.
>The problem arises when there are some records in the files which have
>the same key ( which is supposed to be unique in the table). Now, the
>whole insert action is failed and none of the 200 records was inserted.
>My question is this: is there a way for me to retreive the INDEX of the
>record that failed? ( let's say that i get an error saying : "record no.
>95 failed to be inserted" ). That way i can remove the faulty record and
>try again.
>
>Thanks in advance for any advice,
> Yaki
>--
>Don't take your organs to heaven.
>Heaven knows we need them here...
Received on Mon Mar 15 1999 - 10:55:16 CST
