Connecting to Oracle 11g with perl 5.6.1

2011-10-04 Thread Shobha Deepthi V (sobv)
Hi, I have a perl program that is using Perl 5.6.1 and Oracle 10g. We have migrated the database from 10g to 11g. I modified ORACLE_HOME to use 11g database. However, now the program fails with, ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) Anything else

DBD ERROR: LOB refetch attempted for unsupported statement type

2011-09-03 Thread Shobha Deepthi V (sobv)
Hi, I am calling a stored procedure that returns ref cursor from perl. But it fails with the following error, DBD::Oracle::st execute failed: ( DBD ERROR: LOB refetch attempted for unsupported statement type ) I searched for this error, and all the results show how to read a CLOB