in reply to Re: PERL DBI Oracle
in thread PERL DBI Oracle

Hello Moron,

You code worked but if sql queries returns more than 2 rows , it still shows 2 entries. Is there wany way to change it.

For example your code returns

F:\perl\bin>perl C:\eHealth\custom\Script\nodata_l.pl
BP-ALL-SITES, BP_COCO

But actual result of query has 3 rows

BP-ALL-SITES
BP_COCO
CMS-Monitoring


Farhan

Replies are listed 'Best First'.
Re^3: PERL DBI Oracle
by Moron (Curate) on May 16, 2007 at 12:36 UTC
    Aha, I was interpreting an even number of rows from the OP. I think I would need to know what "works" means to you for an odd number of rows in that case. Update: Or is the three rows an unhandled error condition you are talking about?Also, if there are four rows, how do we know whether they are two pairs or not?
    __________________________________________________________________________________

    ^M Free your mind!