FW: Perl Oracle incompatibility
From: Rachita (rachita.sachdeva_at_bhartitelesoft.com)
Date: 10/28/04
- Next message: Lubomir G. Vassilev: "Error: Can't load '/cygdrive/c/Oracle/Ora81/bin/Oracle' for module DBD::Oracle..."
- Previous message: Jeff Urlwin: "RE: 5.8.4 test-simple.ppd not found"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
To: <dbi-users@perl.org> Date: Thu, 28 Oct 2004 22:17:53 +0530
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
- Next message: Lubomir G. Vassilev: "Error: Can't load '/cygdrive/c/Oracle/Ora81/bin/Oracle' for module DBD::Oracle..."
- Previous message: Jeff Urlwin: "RE: 5.8.4 test-simple.ppd not found"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
