DBI->connect() fails
am 17.09.2006 10:17:24 von Madhu.KiranHi,
DBI->connect() returns a NULL handle in Perl 5.6.1 if ORA-28002 is hit
in Database. ORA-28002 stands for "password will expire in
DBI->connect() returns the db connection handle in Perl 5.8.3 even if
ORA-28002 is hit in Database.
ORA-28002 is just a warning as so behaviour in 5.8.3 is correct and not
in 5.6.1.
I think Perl 5.8.3 logs into Oracle Database using OCISesionBegin(). I
heard that Perl 5.6.1 logs into Oracle Database using older oci APIs,
but not sure about this.
Can someone please explain to me how Perl 5.6.1 connects to Oracle
Database and gets the db connection handle and how does it handle ORA-28002?
Thanks & Regards,
- Madhukiran