in reply to Re: How to use oracle SHOW commands with DBI
in thread How to use oracle SHOW commands with DBI

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

  • Comment on Re^2: How to use oracle SHOW commands with DBI

Replies are listed 'Best First'.
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"))'
    -- 
    I hate storms, but calms undermine my spirits.
     -- Bernard Moitessier, "The Long Way"