Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!border3.nntp.aus1.giganews.com!nntp2.aus1.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!fu-berlin.de!uni-berlin.de!144.139.99.235!not-for-mail
From: "Chris \( Val \)" <chrisval@bigpond.com.au>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Viewing code in stored procedures and functions
Date: Mon, 3 Mar 2003 19:13:14 +1100
Lines: 52
Message-ID: <b3v2qq$1qe666$1@ID-110726.news.dfncis.de>
References: <b3kqkh$1nv0qe$1@ID-110726.news.dfncis.de> <1046343717.620180@news.thyssen.com> <b3ku4k$1lqb4h$1@ID-110726.news.dfncis.de> <b3sp7g$1q1t95$1@ID-110726.news.dfncis.de> <b3sumq$1pnu9v$1@ID-110726.news.dfncis.de> <b3svku$1pdlvl$1@ID-110726.news.dfncis.de> <b3t4me$1pkgn1$2@ID-82536.news.dfncis.de>
NNTP-Posting-Host: 144.139.99.235
X-Trace: fu-berlin.de 1046679195 61282502 144.139.99.235 (16 [110726])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:94268
X-Received-Date: Mon, 03 Mar 2003 01:13:10 MST (news.easynews.com)


"Rene Nyffenegger" <rene.nyffenegger@gmx.ch> wrote in message
news:b3t4me$1pkgn1$2@ID-82536.news.dfncis.de...
|
| >
| > "Chris ( Val )" <chrisval@bigpond.com.au> wrote in message
| > news:b3sumq$1pnu9v$1@ID-110726.news.dfncis.de...
| >|
| >| "Chris ( Val )" <chrisval@bigpond.com.au> wrote in message news:b3sp7g$1q1t95$1@ID-
| >|
| >| [snip question]
| >|
| >| Hi everyone, I found what I was after, and that was: ALL_SOURCE.
| >|
| >| I'm still interested in any good books though :-).
| >
| > DOH!.
| >
| > It didn't work after all. Silly me had an existing procedure
| > which wasn't in a package. That's where the view of the source
| > code came from.
| >
| > Any ideas ?.
| >
| > Cheers.
| > Chris Val
|
|
| Chris
|
| You were nonetheless right about xyz_SOURCE.
|
| select text from xyz_SOURCE where type = 'PACKAGE BODY' and name = '<package
| name>' and so on. Unfortunatly, it's not possible look at a specific
| procedure/function within the package without parsing the text of the package
| yourself (that is, I wouldn't know of a possibility). So, you can only look at
| the entire package.

Hi Rene.

That is unfortunate, however I appreciate the help.

Cheers.
Chris Val


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.454 / Virus Database: 253 - Release Date: 10/02/2003