On Thu, Oct 28, 2004 at 02:28:52PM -0600, Reidy, Ron wrote: > 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 ...?
Or forget to upgrade DBD::Oracle... Tim. > ----------------- > 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. > >
