Re: RE: Oracle PL/SQL and CLOBS

2004-07-23 Thread djones
ginal message- From: Steven Erat [EMAIL PROTECTED] Date: Fri, 23 Jul 2004 14:40:18 -0400 To: CF-Talk [EMAIL PROTECTED] Subject: RE: Oracle PL/SQL and CLOBS >  David, >    >  Assuming this is Oracle, if you're using the Macromedia drivers with a >  stored procedure that has an ou

RE: Oracle PL/SQL and CLOBS

2004-07-23 Thread Steven Erat
David, Assuming this is Oracle, if you're using the Macromedia drivers with a stored procedure that has an output parameter type of varchar2, then even though the varchar2 datatype can hold up to 32k the Macromedia Oracle driver will only return the first 4k.  If you use the Oracle Thin Client i

Re: Oracle PL/SQL and CLOBS

2004-07-23 Thread djones
ECTED] Subject: Re: Oracle PL/SQL and CLOBS >  Hi David, >   >  You've explained what you're trying to implement but >  not enough of why you've chosen to implement things >  this way. >   >  CLOBS are slow so you should try to avoid them unless >  necessary,

Re: Oracle PL/SQL and CLOBS

2004-07-23 Thread I-Lin Kuo
Hi David, You've explained what you're trying to implement but not enough of why you've chosen to implement things this way. CLOBS are slow so you should try to avoid them unless necessary, but I don't have enough of an understanding of what problem you're trying to solve to say whether or not y