Re: Print a procedure text.

From: SG <Serguei_Goumeniouk_at_ca.ml.com>
Date: Thu, 20 Dec 2001 16:41:26 -0500
Message-ID: <3C225B06.82C0CD3C@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 Thu Dec 20 2001 - 15:41:26 CST