in reply to DBI & Cursors

Joe, what version of DBI are you using? I had problems using cursors in Oracle with older versions as there were some bugs.

Where in your code is the cursor opened? I did not see that part, is it done in the PLSQL not shown?

Are you importing the ORA_RSET into your program? I usually have to do a use DBD::Oracle qw(:ora_types) explicitly.

Replies are listed 'Best First'.
Re^2: DBI & Cursors
by joec_ (Scribe) on Nov 21, 2008 at 16:21 UTC
    hi, yes the cursor is opening in the pl/sql and i am using DBD::Oracle qw(:ora_types). I think the problem here is that in pl/sql when i run the procedure with the declare section and all, i have to use the line declare s_cur Pacdesignset.structure_cur because within that, a cartridge is used to convert the molecule structure from one format into a CLOB called a molfile. Now in order for me to bind that as an out parameter i would do Pacdesignset.get_data(5000,1,:s_cur), but and this is the killer but, can i do declare s_cur Pacdesign.structure_cur; begin Pacdesignset.get_data(5000,1,:s_cur) to still get at it as a bind variable even though it has been declared as a specific thing and not a placeholder?

    How do i know what version of DBI im using?

    Thanks

    Joe

    P.S. Sorry for being so verbose.

[reply]
[d/l]
[select]
      perl -M"DBI 9.99"

      Or open up the DBI.pm file and look for $VERSION

[reply]
[d/l]
[select]
        Hi, im using version 1.51 of DBI. Thanks. Joe.
[reply]

In Section Seekers of Perl Wisdom