RE: Perl Oracle incompatibility

From: Rachita (rachita.sachdeva_at_bhartitelesoft.com)
Date: 10/29/04 

To: "Tim Bunce" <Tim.Bunce@pobox.com>, "Reidy, Ron" <Ron.Reidy@arraybiopharma.com>
Date: Fri, 29 Oct 2004 10:37:21 +0530

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

Relevant Pages

  • RE: Memory fault(coredump) with two DBD type connections
    ... I get a core dump ... all the libraries are the same threaded model(single threaded perl uses ... I am running Perl 5.8.8 with DBD-Oracle 1.19 compiled against Oracle ... when I try to connect to the same Oracle database AND same DB2 database ...
    (perl.dbi.users)
  • RE: Problem with connecting to an Oracle database using Perl
    ... specifically ORACLE_HOME and maybe the NLS vars. ... Problem with connecting to an Oracle database using Perl ...
    (perl.dbi.users)
  • Re: DBD::Oracle crashes non-deterministic
    ... No, unfortunately it really CRASHES perl, i.e. it dumps core in the oracle ... One difference we have found is that if we are targetting a 9i R2 Database ...
    (perl.dbi.users)
  • Re: Urgent!! Need help on AIX Migration
    ... I'm working on Oracle 8.1.7.4 database on AIX5.2. ... Next...after the OS upgrade, relink the Oracle executable. ...
    (comp.databases.oracle.server)
  • Re: SQLPlus with Perl
    ... I've been assigned a project involving SQLplus calls to an Oracle ... database within Perl code. ... now need to perform a select statement to check values in the database. ...
    (comp.lang.perl.misc)