Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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'"); ...

rdfield


Comment on Re: DBI: Identify schema objects for a statement
Select or Download Code
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://635794]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (19)
As of 2014-07-24 16:43 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (162 votes), past polls