Release 3.00
Apr 17, 2005
|
Sybernet / Supplied Procedures Reference
Release 3.00 Apr 17, 2005 |
|
This procedure lists all objects that reference the object you specify, all the objects that it is dependent upon, or both. Since all references are created as hypertext links, you should set the output format to suppressed. Clicking any link will call sp_depends for that object. If run from the Sybernet Interactive SQL and Editor, you can click on each object type to view or edit this object.
Procedure SP_DEPENDS
(
OBJECTNAME VARCHAR2
) ;
| Parameter | Description |
|---|---|
objectname |
The name of the object. |
The following example illustrates how to call sp_depends:
http.sp_depends('SP_HTML_FRAME');
The output resembles the following:
Things the object references in the current database. object type -------------------------------------------------- ------------------------------ HTTP.OBJECT_ID FUNCTION HTTP.SERVERNAME FUNCTION HTTP.SP_AUDIT PROCEDURE HTTP.SP_GETPREFERENCE PROCEDURE HTTP.SP_HTML_PREFERENCES PROCEDURE HTTP.WRITE PROCEDURE HTTP.WRITELN PROCEDURE SYS.DBMS_STANDARD PACKAGE SYS.PLITBLM PACKAGE SYS.STANDARD PACKAGE SYS.SYS_STUB_FOR_PURITY_ANALYSIS PACKAGE SYS.ALL_ARGUMENTS VIEW Things inside the current database that reference the object. object type -------------------------------------------------- ------------------------------ HTTP.SP_HTML_CRON_MONITOR PROCEDURE HTTP.SP_HTML_CRON_REGISTER PROCEDURE HTTP.SP_HTML_EDITOR PROCEDURE HTTP.SP_HTML_GRANT PROCEDURE HTTP.SP_HTML_HELPTEXT PROCEDURE HTTP.SP_HTML_ISQL PROCEDURE HTTP.SP_HTML_ISQL_NEW PROCEDURE HTTP.SP_HTML_LEIBNITZ PROCEDURE HTTP.SP_HTML_PREFERENCES_FORM PROCEDURE HTTP.SP_HTML_PROCMAN PROCEDURE HTTP.SP_HTML_REGISTER PROCEDURE HTTP.SP_HTML_UPLOAD PROCEDURE HTTP.SP_HTML_UPLOAD_EXAMPLE_1 PROCEDURE HTTP.SP_HTML_UPLOAD_EXAMPLE_2 PROCEDURE HTTP.SP_HTML_UPLOAD_EXAMPLE_3 PROCEDURE HTTP.SP_HTML_UPLOAD_EXAMPLE_4 PROCEDURE HTTP.VI PROCEDURE