It would help if you could show us a small piece of code that demonstrates the problem. At least the SQL + bind_param calls etc.
http://www.catb.org/~esr/faqs/smart-questions.html Tim. On Fri, Oct 29, 2004 at 10:37:21AM +0530, Rachita wrote: > Hi Tim / Reidy, > > Thanks for the info. > > The same procedure is running perfectly fine when I run it at SQL Plus > prompt. Moreover i have not done any changes except to upgrade my Oracle > from 8.1.7 to Oracle 9.2.0.1.0 > > I have 2 servers. On the production server, I have just upgraded the > database and nothing else. So there are libclntsh.so.8.0 > and libclntsh.so files present. > > But on the other server i.e. Test server I have upgraded the database and > then rebuilded perl. So I have libclntsh.so.9.0 and libclntsh.so files > present > > In either case it is not working. I have not made any changes in the > procedure at all and it was working fine before I upgraded the databse. > > Plz. help as this is very urgent and my clients are waiting for the reports. > > With regards, > Rachita > > -----Original Message----- > From: Tim Bunce [mailto:[EMAIL PROTECTED] > Sent: Friday, October 29, 2004 2:51 AM > To: Reidy, Ron > Cc: Rachita; [EMAIL PROTECTED] > Subject: Re: Perl Oracle incompatibility > > > 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. > > > > >
