Re: DBI: Identify schema objects for a statement


Keep It Simple, Stupid
	PerlMonks

Re: DBI: Identify schema objects for a statement

by rdfield (Priest)

on Aug 29, 2007 at 13:13 UTC ( #635794=note: print w/replies, xml )

Need Help??

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'");
...
[download]

rdfield

Comment on Re: DBI: Identify schema objects for a statement Select or Download Code

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.	[reply]

In Section Seekers of Perl Wisdom

Node Status^?

node history
Node Type: note [id://635794]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others contemplating the Monastery: (6)

As of 2021-03-01 16:55 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

Notices^?