Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: How to use oracle SHOW commands with DBI

by oko1 (Deacon)
on Feb 17, 2012 at 07:09 UTC ( #954421=note: print w/ replies, xml ) Need Help??


in reply to How to use oracle SHOW commands with DBI

Try "$dbh->do()" instead of "prepare/execute". "do()" is, according to the DBI documentation, what you're supposed to use for non-SELECT statements.

-- 
I hate storms, but calms undermine my spirits.
 -- Bernard Moitessier, "The Long Way"


Comment on Re: How to use oracle SHOW commands with DBI
Re^2: How to use oracle SHOW commands with DBI
by Anonymous Monk on Feb 17, 2012 at 07:24 UTC

    FWIW, SHOW is a select statement, if you do, there are no rows to retrieve

      Looks like you're right. I don't have an Oracle DB to test, but I just played around with it on a MySQL DB, and invoking 'SHOW' this way works fine:

      perl -MData::Dumper -MDBI -we'$x=DBI->connect("dbi:mysql:wp", "yeah", +"fer_sure"); print Dumper($x->selectall_arrayref("SHOW VARIABLES"))'
      -- 
      I hate storms, but calms undermine my spirits.
       -- Bernard Moitessier, "The Long Way"

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2014-09-17 04:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (57 votes), past polls