Re: Oracle CLOBs as SP Parameters

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sat, 31 Mar 2001 23:14:25 -0800
Message-ID: <3AC6D551.7AB84697@exesolutions.com>

> 1. How is the CLOB defined in your ADO Command Parameter - I'm using
> adVarChar with a size of approximately 2 billion characters

I don't know. I am the DBA responsible for the back-end. What I know is that the middle tier is passing in CLOBS. And that we are having no problems utilizing them in any manner from writing to a table to using the DBMS_LOB procedures to work with them.

> 2. How do you handle the CLOB on the stored procedure side of things? A
> simple insert statement or a DBMS_LOG.WRITE? The docs state that the WRITE
> procedure only handles up to a max of around 32 K of characters. What if
> the CLOB is larger than that?

Not using DBMS_LOB (I presume you meant LOB not LOG) to insert into a table. Just a straight SQL insert statement.

Daniel A. Morgan Received on Sun Apr 01 2001 - 01:14:25 CST