This is not a Perl issue. There is an issue with PL/SQL proc - maybe some variable is too small for the data? Or did you change character sets? Or ...?
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Rachita [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 10:48 AM To: [EMAIL PROTECTED] Subject: FW: Perl Oracle incompatibility Hi dbi users, I have been struggling with this for quite some time, going thru various articles, faqs and mailing lists, but still not able to go thru. I have perl, v5.6.0 built for i386-linux and DBI 1.20 and DBD::ORACLE 1.12 running with Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production. I have a perl file for generating summary reports by interacting with the Oracle database. All the database queries work fine till it encounters the query where a stored procedure is being called. At this poing I get the following error: DBD::Oracle::st execute failed: ORA-06502: PL/SQL: numeric or value error: character string buffer too small DBD ERROR: OCIStmtExecute DBD::Oracle::st fetchrow_array failed: ERROR no statement executing (perhaps you need to call execute first) It was working fine with oracle 8.1.6 and 8.1.7 I guess some configuration settings have to be done for my perl to execute the stored procedure written in oracle. Thanks in advance. Awaiting ur reply. Regards, Rachita This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
