Home » SQL & PL/SQL » SQL & PL/SQL » Parse of PL/SQL package Spec (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
Parse of PL/SQL package Spec [message #397917] Tue, 14 April 2009 09:48 Go to next message
annagel
Messages: 220
Registered: April 2006
Senior Member
Does anyone know of any built in PL/SQL utility which will parse a package spec and tell me something structurally about the package. Specifically the function, procedures and parameter/parameter-type list for each procedure/function in the spec. It is possible given just the information in the all_source view to accomplish this with a little bit of work which I am willing to do if it comes to that, but I figured it was worth checking to see if Oracle already has a built-in utility which would do a good deal of the work for me.

Thanks for any idea,
Andrew
Re: Parse of PL/SQL package Spec [message #397920 is a reply to message #397917] Tue, 14 April 2009 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Specifically the function, procedures and parameter/parameter-type list for each procedure/function in the spec.

This is in ALL_ARGUMENTS view.

Regards
Michel
Re: Parse of PL/SQL package Spec [message #397925 is a reply to message #397920] Tue, 14 April 2009 09:58 Go to previous messageGo to next message
annagel
Messages: 220
Registered: April 2006
Senior Member
Perfect Smile Thanks
Re: Parse of PL/SQL package Spec [message #397941 is a reply to message #397925] Tue, 14 April 2009 12:00 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
How about DESCRIBE?
SQL> descr dbms_output
PROCEDURE DISABLE
PROCEDURE ENABLE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 BUFFER_SIZE                    NUMBER(38)              IN     DEFAULT
PROCEDURE GET_LINE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LINE                           VARCHAR2                OUT
 STATUS                         NUMBER(38)              OUT
PROCEDURE GET_LINES
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LINES                          TABLE OF VARCHAR2(32767) OUT
 NUMLINES                       NUMBER(38)              IN/OUT
PROCEDURE GET_LINES
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 LINES                          DBMSOUTPUT_LINESARRAY   OUT
 NUMLINES                       NUMBER(38)              IN/OUT
PROCEDURE NEW_LINE
PROCEDURE PUT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 A                              VARCHAR2                IN
PROCEDURE PUT_LINE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 A                              VARCHAR2                IN

SQL>
Re: Parse of PL/SQL package Spec [message #397942 is a reply to message #397941] Tue, 14 April 2009 12:03 Go to previous message
annagel
Messages: 220
Registered: April 2006
Senior Member
This could also probably be made to work but I think Michel's solution works best for my purposes as it gets me all the information I need in a nice and easy to consume format.
Previous Topic: Group by help (merged)
Next Topic: UTL_FILE.GET_LINE
Goto Forum:
  


Current Time: Tue Dec 06 14:16:32 CST 2016

Total time taken to generate the page: 0.22473 seconds