-- Author: Ahbaid Gaffoor - OCPdba.Net -- Date: Sunday 18th August 2002 -- File: showdeps.sql -- Purpose: SQL wrapper script for show_dependencies procedure -- Usage: @showdeps OWNER OBJECT_NAME OBJECT_TYPE -- Example: @showdeps SCOTT EMPLOYEE TABLE set serveroutput on size 400000 set lines 130 set pages 0 set verify off begin show_dependencies(upper('&&1')||'.'||upper('&&2')||'.'||upper('&&3')); end; / set verify on