Re: Oracle Stored Proc problem

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 06 Sep 2006 20:52:32 +0200
Message-ID: <edn5df$rem$03$1@news.t-online.com>

KK schrieb:
> Is there any way to declare a variable in stored procedure that should
> hold --- length of text which is not known at design time.
>

> In the above example If I use vDupTxt VARCHAR(---), I have to specify
> length (1.. 32767)
>
> While executing the stored procedure at runtime, some times I may want
> to assign longer text.
>
> Appreciate your help!
>
> Thanks
>

PL SQL variables are limited to 32K (i.e. you can't assign a longer value to pl sql variable).

Best regards

Maxim Received on Wed Sep 06 2006 - 13:52:32 CDT