DBI->connect() fails

DBI->connect() fails

am 17.09.2006 10:17:24 von Madhu.Kiran

Hi,

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 days".

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