Display Packages in SQL*Plus?

1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #168,721 by tablizer 8/11/04 4:12:32 PM Reply	Display Packages in SQLPlus? Does anybody know how to display package code in SQLPlus? not just parameters. I need a way to bulk save all the package code to files. I can get them one at a time in Toad, but there are potentially hundreds. I believe I can get a list of the package names, but need a way to feed that list into something that can generate and capture code listings. ________________ oop.ismad.com
Post #168,734 by ChrisR 8/11/04 4:40:19 PM Reply	Could probably use some variation of USER_SOURCE view somthing along the lines of: SELECT * FROM user_source WHERE type = 'PACKAGE'; Where the returned columns are: (OWNER, NAME, TYPE, LINE, TEXT)
Post #168,745 by admin 8/11/04 5:01:59 PM Reply	That's what we do here. Regards, -scott anderson "Welcome to Rivendell, Mr. Anderson..."
Post #168,787 by tablizer 8/11/04 7:36:13 PM Reply	Re: Could probably use some variation of USER_SOURCE view Good suggestion. Thanks. Unfortunately, it contains only a single procedure, no packages. My user role must hide the others from me or something. ________________ oop.ismad.com
Post #168,812 by ChrisR 8/11/04 9:37:08 PM Reply	how about DBA_SOURCE? Of course, that assumes you have dba rights.
Post #168,813 by ChrisR 8/11/04 9:39:11 PM Reply	or ALL_SOURCE?
Post #168,897 by tablizer 8/12/04 12:28:04 PM Reply	So far the most promising. Thanx ________________ oop.ismad.com

Display Packages in SQL*Plus? - (tablizer) - (6) - Aug. 11, 2004, 04:12:32 PM EDT

Could probably use some variation of USER_SOURCE view - (ChrisR) - (5) - Aug. 11, 2004, 04:40:19 PM EDT

That's what we do here. -NT - (admin) - Aug. 11, 2004, 05:01:59 PM EDT

Re: Could probably use some variation of USER_SOURCE view - (tablizer) - (3) - Aug. 11, 2004, 07:36:13 PM EDT

how about DBA_SOURCE? - (ChrisR) - (2) - Aug. 11, 2004, 09:37:08 PM EDT

or ALL_SOURCE? -NT - (ChrisR) - (1) - Aug. 11, 2004, 09:39:11 PM EDT

So far the most promising. Thanx -NT - (tablizer) - Aug. 12, 2004, 12:28:04 PM EDT

It's like a nuclear blast in the basement.
63 ms