IMHO you can try the following way :).
Write pl/sql function which can insert the record into table.
This function can return for example 0-success
index number -if not one.
Second if you want to insert the package of records.
May be you ought to make the temporary table which can contain
the indexes which were falled. Your function can return the ref cursor.
Ok.
Unfortunately I think you can catch only the OCI messages about errors and
there is no way to get the falled indexes as you want.
Vladimir
Yacov Wolfowicz wrote in message <36EDE8A9.A351EC5E_at_rose.ecitele.com>...
>Vladimir Schukin wrote:
>>
>> Do you insert your files as BLOB or what?
>
>No. The files are binaries, translated to simple data records ( varchar,
>number etc.). No BLOBs.
>
>Thanks for the advaice.
>
>--
>Don't take your organs to heaven.
>Heaven knows we need them here...
Received on Tue Mar 16 1999 - 10:44:06 CST
