This content has been marked as final. Show 2 replies
Yes, DBD::Oracle uses OCI and it should work.
I suspect that ORACLE_HOME is not set in DBD::Oracle's environment.
How is DBD::Oracle invoked? From a web server? From the command line?
Try to output the Oracle environment with Perl before you call DBD::Oracle.
Environment variables was correctly defined, but your comment put me on the right track.
I printed the %ENV content to check ORACLE_HOME which was OK.
I check the directory and remind I put a sqlnet.ora file in the same directory than tnsnames.ora with the followin content :
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
I removed this file and everything is ok now. I don't really know what this file is used for, but if I keep it online and change MYDB in the connection name to MYDB.world, it worked. I think I have to learn more about names...
Thanks for your help anyway !