Re: Oracle CLOBs as SP Parameters

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 31 Mar 2001 01:47:53 -0800
Message-ID: <3AC5A7C9.30BE0EE2@exesolutions.com>

> Has anyone been able to successfully pass a large amount of text as CLOB IN
> parameter into an Oracle 8i stored procedure and use the parameter to update
> a CLOB field in the database?
>
> I'm using VB and ADO along with Oracle 8i and the Oracle OLE DB provider,
> but even an SP calling another SP example would be relevant.
>
> This one has thrown me for a loop!
>
> Oracle CLOBs as SP Parameters

I am currently passing CLOBS into Oracle packages from an XML middle tier. It is possible and it works quite well using OLEDB.

Daniel A. Morgan Received on Sat Mar 31 2001 - 03:47:53 CST