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.
> >
> >
> 

Reply via email to