Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: How to use oracle SHOW commands with DBI

by oko1 (Deacon)
on Feb 17, 2012 at 07:09 UTC ( [id://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"

Replies are listed 'Best First'.
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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://954421]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (8)
As of 2024-03-28 11:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found