K
Kjetil Skotheim
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.
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.