Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie - How do I view Stored Procedure source?
rforde48_at_hotmail.com said...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3e96cc7b$0$29711$ed9e5944_at_reading.news.pipex.net>...
> > "Ricky" <rforde48_at_hotmail.com> wrote in message
> > news:609a5433.0304110533.58a254e6_at_posting.google.com...
> > > Hi. I'm trying to figure out how I would view the source for a stored
> > > procedure from SQL/Plus? Is there some kind of command?
> >
> > select text from user source where name ='<your proc name>' order by line ;
>
> What is 'user source'?
>
A typo. It should have been: select text from user_source...
But be aware that the text column is just a 4000-byte string, so it might wrap at funny places.
-- /Karsten DBA > retired > DBAReceived on Fri Apr 11 2003 - 14:38:46 CDT