Is it a must to declare length?
Maxim Demenko wrote:
> 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 - 14:13:41 CDT
