Perl and Oracle, deferred constraints stopped working in new version

Discussion in 'Perl Misc' started by Kjetil Skotheim, Jun 16, 2004.

  1. A question on Perl and Oracle:

    We're having trouble with alter session set constraints=deferred
    through perl after some major upgrades on OS and perl on our server.
    It used to work, but not anymore. That is: it still works perfecly
    well through sqlplus. Using precicely the same update's in the same
    order.

    Deferred constraints is a mechanism in oracle that makes is possible
    to postpone the foreign and unique keys control until commit instead
    of immediately after each update/insert/delete.

    I'm using DBI.pm indirectly via sub ora_do in Oraperl.pm due to
    a local legacy library.

    Oraperl version is 1.43
    DBI version is 1.39
    DBD::Oracle is 1.14
    perl -v says 5.8.0
    Oracle client (for both DBD::Oracle and sqlplus) I think is 8.1.7
    Oracle server is 8.1.7.4.0

    Good answers would be greatly appreciated.

    --
    Kjetil Skotheim
     
    Kjetil Skotheim, Jun 16, 2004
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. V Green
    Replies:
    0
    Views:
    925
    V Green
    Feb 5, 2008
  2. PA Bear [MS MVP]
    Replies:
    0
    Views:
    1,036
    PA Bear [MS MVP]
    Feb 5, 2008
  3. Feyruz
    Replies:
    4
    Views:
    2,338
    Sherm Pendley
    Oct 14, 2005
  4. Replies:
    6
    Views:
    222
    Thomas 'PointedEars' Lahn
    Feb 22, 2006
  5. Replies:
    2
    Views:
    119
    Randy Webb
    Nov 12, 2006
Loading...

Share This Page