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
