Re: Print a procedure text.

From: Mahendra C <mahendrac_at_vsnl.com>
Date: Fri, 21 Dec 2001 19:14:10 +0530
Message-ID: <a00gvd$no8$1@news.vsnl.net.in>

Use set arraysize 5

Regards
Mahendra

SG <Serguei_Goumeniouk_at_ca.ml.com> wrote in message news:3C225B06.82C0CD3C_at_ca.ml.com...
> Hi,
> I tried, but have the error: "buffer overflow. Use SET command to reduce
> ARRAYSIZE or increase MAXDATA".
> I tried to SET MAXDATA 1000, but it does not help.
> How can I fix this problem?
> Regards,
> Serguei.
>
> Sybrand Bakker wrote:
>
> > "SG" <Serguei_Goumeniouk_at_ca.ml.com> wrote in message
> > news:3C22394F.3A5C84D0_at_ca.ml.com...
> > > Dear Experts,
> > > How can I print out a text of a stored procedure?
> > > Regards,
> > > Serguei.
> > >
> >
> > select text
> > from user_source
> > where name = '<your name>'
> > order by line
> > /
> >
> > Hth
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
>
Received on Fri Dec 21 2001 - 07:44:10 CST