http://qs321.pair.com?node_id=635794


in reply to DBI: Identify schema objects for a statement

Although v$sql_plan does mention views, it's not complete (especially for simple views). However you could wrap up the sql in a procedure and look at dba_dependencies:
$dbh->do("create or replace procedure test1 as cursor c1 is $sql; begin null; end; "); $dbh->parse("select referenced_name,referenced_type from dba_dependencies where name = 'TEST1' and type = 'PROCEDURE'"); ...

rdfield

Replies are listed 'Best First'.
Re^2: DBI: Identify schema objects for a statement
by Errto (Vicar) on Aug 29, 2007 at 14:49 UTC
    Tried that and it worked great. Thanks. Creating and dropping procedures all the time seems somehow drastic, but sometimes you gotta do what you gotta do.