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 |
In Section
Seekers of Perl Wisdom