RE: Perl Oracle incompatibility

From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 14:28:52 -0600
To: "Rachita" <rachita.sachdeva@bhartitelesoft.com>, <dbi-users@perl.org>

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

-----------------
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: make problem
    ... Perl may be copied only under the terms of either the Artistic License or the ... This electronic message transmission is a PRIVATE communication which contains information ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)
  • RE: make problem
    ... What version **exactly** of Oracle ... Perl may be copied only under the terms of either the Artistic License or the ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)
  • RE: oracle delete has no effect
    ... did you commit the transaction before you ran your Perl program? ... oracle delete has no effect ... > sender of the delivery error by replying to this message, or notify us by ... intended recipient, please be aware that any disclosure, copying, distribution ...
    (perl.dbi.users)
  • RE: DBD-Oracle
    ... Can you tnsping the DB instance you are attempting to connect to in your Perl program? ... I could able to download it now. ... intended recipient, please be aware that any disclosure, copying, distribution ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: Retrieving data from Oracle
    ... Subject: Retrieving data from Oracle ... I'm migrating a perl application in postgres to Oracle. ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)