Re: Oracle Stored Proc problem

KK wrote:
> 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

Do not top post.

Yes, it is a 'must' to declare a length.

David Fitzjarrell Received on Wed Sep 06 2006 - 14:22:36 CDT