in reply to Retrieving result sets using stored procedures (DBI, DBD::Oracle)

Code works fine using Personal Oracle 8.1.6 on Win98, Activestate 623, DBI version 1.14 and DBD::Oracle version 1.06.

You might want to re-install DBI/DBD - remember to use DBD::Oracle8 from Activestate's 6xx archive rather than DBD::Oracle - unless of course you're using Oracle v7.

rdfield

  • Comment on Re: Retrieving result sets using stored procedures (DBI, DBD::Oracle)

Replies are listed 'Best First'.
Re: Re: Retrieving result sets using stored procedures (DBI, DBD::Oracle)
by gsiems (Deacon) on Jul 01, 2002 at 12:13 UTC

    Sadly, I get the same result using DBD-Oracle8...

    The particulars on my development box being:
    - ActiveState ActivePerl 5.6.1.632
    - DBD-Oracle version 1.06
    - DBI version 1.23
    - OS: MS Win2k
    - Oracle client: Release 9.0.1.0.1
    - Oracle server: Oracle8i Enterprise Edition Release 8.1.7.3.0

    I am suspicious of the Oracle 9 client...

[reply]
      I am suspicious of the Oracle 9 client...

      ...installing an 8.1.x client would be my next guess: everything else looks OK. In fact I'm surprised that you got as far as you did with a 9i client :)

      rdfield

[reply]
        FYI,

        It appears that things are just a bit pickier using DBI than I'm used to...

        In the package description, I changed the where clause of the select: 
           s/job = job_in/RTRIM (job) = RTRIM (job_in)/;

        [download]
        and...success (using the oracle 9 client no less!). :-)

        gsiems
[reply]
[d/l]

In Section Seekers of Perl Wisdom