Re: Perl Oracle incompatibility
From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 10/29/04
- Previous message: Rachita: "RE: Perl Oracle incompatibility"
- In reply to: Rachita: "RE: Perl Oracle incompatibility"
- Next in thread: Rachita: "RE: Perl Oracle incompatibility"
- Reply: Rachita: "RE: Perl Oracle incompatibility"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 29 Oct 2004 10:42:43 +0100 To: Rachita <rachita.sachdeva@bhartitelesoft.com>
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:Tim.Bunce@pobox.com]
> Sent: Friday, October 29, 2004 2:51 AM
> To: Reidy, Ron
> Cc: Rachita; dbi-users@perl.org
> 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:rachita.sachdeva@bhartitelesoft.com]
> > Sent: Thursday, October 28, 2004 10:48 AM
> > To: dbi-users@perl.org
> > 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.
> >
> >
>
- Previous message: Rachita: "RE: Perl Oracle incompatibility"
- In reply to: Rachita: "RE: Perl Oracle incompatibility"
- Next in thread: Rachita: "RE: Perl Oracle incompatibility"
- Reply: Rachita: "RE: Perl Oracle incompatibility"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
