Parse of PL/SQL package Spec [message #397917] |
Tue, 14 April 2009 09:48  |
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 #397941 is a reply to message #397925] |
Tue, 14 April 2009 12:00   |
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>
|
|
|
|