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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Stored Proc issues

Re: Oracle Stored Proc issues

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Sep 2006 21:15:43 +0200
Message-ID: <jg7uf2hja06nqn0bqlhnv4nf5rkuks7g4j@4ax.com>


On 6 Sep 2006 11:47:07 -0700, "KK" <krallabandi_at_gmail.com> wrote:

>
>While executing the stored procedure at runtime, some times I may want
>to assign longer text.

A *stored* procedure is a *stored* procedure isn't it? So either max sure the length is sufficient or use a CLOB instead of a VARCHAR2 or generate an anonymous block on the fly and create an unscalable app.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 06 2006 - 14:15:43 CDT

Original text of this message

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