Re: (Fwd) Perl Oracle incompatibility

From: Jayaraj (jayarajo_at_gmail.com)
Date: 10/29/04 

Date: 28 Oct 2004 23:36:56 -0700

Rachita,

I have encountered similar problem before..
Let me understand your problem..

This problem can be because

1. when you are calling stored procedure from your perl program, you
might have supplied less length to the OUT variable and in the stored
procedure, the value written is more than this length.

2. are using any LONG data type?

Can you give me your perl code where you are invoking the stored
procedure and the srored procedure itself?

Thanks,
Jay

Tim.Bunce@pobox.com (Tim Bunce) wrote in message news:<20041028211347.GA54606@dansat.data-plan.com>...
> ----- Forwarded message from Rachita <rachita.sachdeva@bhartitelesoft.com> -----
>
> Delivered-To: tim.bunce@pobox.com
> X-Pobox-Antispam: Require PTR Record returned DENY: 202.56.229.147 has no PTR record
> X-SPF-Guess: pass (seems reasonable for rachita.sachdeva@bhartitelesoft.com to mail through 202.56.229.147)
> From: "Rachita" <rachita.sachdeva@bhartitelesoft.com>
> To: <tim.bunce@pobox.com>
> Subject: Perl Oracle incompatibility
> Date: Thu, 28 Oct 2004 22:16:44 +0530
> X-ECS-MailScanner: Found to be clean
>
> Hi Tim,
>
> 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. So thought
> of bugging u ???
>
> 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
>
>
> ----- End forwarded message -----

Relevant Pages

  • Help with Oracle stored proc call
    ... Perl old timer, but Oracle & dbi/Oracle dbd newbie. ... an example of how to call a stored procedure. ... How would you call it from Perl DBI? ... Do I have to furnish ALL the parameters, or only the ones that I ...
    (perl.dbi.users)
  • Calling a SQL Server Stored Procedure from within Perl
    ... I'm trying to call a simple Stored Procedure from within my Perl ... I tested the SP named "usp_test" in the Query Analyzer and it ... My perl script looks like this ...
    (comp.lang.perl.misc)
  • Re: Error in calling stored procedure via DB link
    ... "Paul Clement" wrote: ... Below is an Oracle KB article that documents the issue. ... Calling Stored Procedure over Dblink Using Oracle OleDb Provider Fails ... > symptom: Using command type adCmdStoredProc ...
    (microsoft.public.vb.database.ado)
  • Re: Performance problems with StoredProcedure in Web application
    ... you could probably just ignore my comments about stored procedure performance as compared to textual queries because they ... As for your question about how to avoid using a cursor (as I suggested was possible in Oracle) read the following paragraph for more ... The .NET Framework Data Provider for Oracle does not support batched SQL statements. ... CURSOR output parameters to fill a DataSet, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Passing Back Table Information from Oracle .NET Stored Procedures
    ... stored procedure, not in the typical PL/SQL sense. ... I don't care if it's MS SQL in-line code or Oracle in-line code, MS SQL Server, Oracle Proc, or this so called .NET Stored Procedure using a Select statement, they are all returning a RESULT SET whether it be one row or multiple rows. ... I used SqlContext above because I don't want to bother registering at the Oracle site to download their Oracle Database Extensions for .NET in order to get at the presumably extant OracleContext class. ...
    (microsoft.public.dotnet.languages.csharp)