passing CLOB in Stored Procedure as IN/OUT

Hi,

I am trying to get an answer for 'Is it required to create a temporary lob before doing an in/out operation on a lob being passed as in/out parameter in a stored-procedure?"

I have seen some of the OCI samples, wherein temporary lob is created using OCILobCreateTemporary call and then we use OCILobWrite or OCILobRead call but could not find a reason to do so.

I think it is logical to create a temporary lob for a table having CLOB column rather for stored-procedure.

any suggestions will be helpful

Thanks,
Sachin Received on Mon Jun 23 2008 - 03:22:41 CDT