Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: C# Program, Passing LongVarChar to Package expecting CLOB.

Re: C# Program, Passing LongVarChar to Package expecting CLOB.

From: LineVoltageHalogen <tropicalfruitdrops_at_yahoo.com>
Date: 3 May 2005 10:27:39 -0700
Message-ID: <1115141259.065056.42500@o13g2000cwo.googlegroups.com>


Steve, thanks for the reply. The issue is a limitation of PL/SQL. You cannot pass more that 32K at a time to PL/SQL and that prevents me from passing the entire clob to the Package. Some work arounds include creating a temporary clob in memory on the server and populating it via the C# code. ONce populated you can then pass that temp clob object to the package, etc. I am tryign to dig up a good C# example of this type of operation.

TFD Received on Tue May 03 2005 - 12:27:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US