Integration

Hi,

I am using perl with the DBI and DBD packages, to access Oracle on solaris machine. However when using the following syntax:

use DBI qw(:sql_types);

# Connect to the Database
my $db = DBI->connect("dbi:Oracle:dbname ", "username", "password" );


I get the following error: DBI connect failed: ORA-24315: illegal attribute type (DBD ERROR: OCIAttrGet OCI_ATTR_ENV_CHARSET_ID) etc

I have checked the tnsnames.ora, it is set up correctly. I'm able to connect using sqlplus username/password@dbname successfully.

In my perl code i'm not setting any atribute at all, still its giving error for this "OCI_ATTR_ENV_CHARSET_ID" particular atribute.


Any help would be greatly appreciated...

Regards