Re: 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

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	[reply]
Re^3: How to use oracle SHOW commands with DBI by oko1 (Deacon) on Feb 17, 2012 at 07:38 UTC
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"))'` [download] -- I hate storms, but calms undermine my spirits. -- Bernard Moitessier, "The Long Way"	[reply] [d/l]