Generate DDL for Oracle Stored Procedure Dependency Graph -

Generate DDL for Oracle Stored Procedure Dependency Graph -

with toad know can view dependency (uses) graph of stored procedure using schema browser. and, oracle utility procedure deptree_fill can similar. want script out of stored procedures, functions , table definition dlls file can utilize recreate objects in database. there tool or existing script purpose? own searching has not found solution. in particular case stored procedure uses dozen other procedures, few functions , 20 tables.

edit 1

maybe original question not clear. looking take stored procedure interested in , script , of dependency graph 1 or more files.

the schema dealing has hundreds of objects in , dependency graph has ~50 objects in it. i'd rather not dig through big lists in toad or write oracle script myself if can avoid it.

hmm, quite easy find in google. table ddl: how oracle create table statement in sql*plus

code of stored procedures can found in table user_source.

also, exporting schema db can utilize oracle utilities: http://docs.oracle.com/cd/b28359_01/server.111/b28319/exp_imp.htm#g1070082

oracle stored-procedures oracle-sqldeveloper toad