Re: OCI: How to insert BLOB?

On Thu, 04 Sep 2003 13:30:21 +0000, Amit wrote:

> Returning clause does works especially prior to Oracle 9. However
> 'returning' SQL construct has some disadvantages and AFAIK it is not a
> recommended choice for Oracle 9i onwards. For one, you cannot send data
to

Do you have any more details on why it is not a recommended to use returning and who is saying so.

> a stored proc. You can with OCILobLocator. Further with returning clause

Yes, but that wasnt the question ;)

> you need to do two step execution. In that case, your table integrity is
> not consistent because in first execution you have just inserted
> EMPTY_CLOB which refers to a temporary buffer area. Suppose before you
> have send the data, another thread tries to read the data?

Could this not happen using the code you posted earlier to this thread. It seams you create a temporary lob, insert it and then write to the lob. These two approaches seem very similar to me.
I would assume that this would all be neatly wrapped up in a transaction in order to preserve integrity.

> This is not a problem with OCILobLocator.
>
> ----------------------------------------------------------------- Amit
> Jindal, Development Engineer
>
>

Cheers,
Stuart. Received on Fri Sep 05 2003 - 04:18:45 CDT