(Fwd) DBD:: Oracle Problems

From: Tim Bunce (Tim.Bunce_at_pobox.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 23:25:56 +0000
To: dbi-users@perl.org

----- Forwarded message from "Rowe,Paul" <Paul.Rowe@gartner.com> -----

Delivered-To: tim.bunce@pobox.com
X-SPF-Guess: pass (seems reasonable for Paul.Rowe@gartner.com to mail through 207.140.148.126)
X-Pobox-Antispam: Bad HELO hostname returned DENY: no A or MX records found for parakeet.ent.gartner.com
Subject: DBD:: Oracle Problems
Date: Thu, 18 Nov 2004 18:19:41 -0500
From: "Rowe,Paul" <Paul.Rowe@gartner.com>
To: <Tim.Bunce@pobox.com>
Cc: "Colon,Anthony" <Anthony.Colon@gartner.com>
X-OriginalArrivalTime: 18 Nov 2004 23:19:46.0178 (UTC) FILETIME=[179F3E20:01C4CDC5]

   Tim, we just recently upgraded to perl 5.8.2 and Oracle:DBD 9.2. We moved over our production scripts
   and
   are receiving the following error when we execute any stored procedures. The code is attached as well.

   Here is the procedure:

   sub kmap_add_resource {
     my $res_id = shift;
     my $sth = $kmap_dbh->prepare("BEGIN link_que_mod_pkg.add_resource(:p1, :p2, :p3, :p4, :p5, :p6, :p7);
   END;") ;
       $sth->bind_param(":p1", $res_id);
       $sth->bind_param(":p2", undef);
       $sth->bind_param(":p3", "N");
       $sth->bind_param(":p4", undef);
       $sth->bind_param(":p5", "TEAMSITE");
       my $return1 = 0;
       my $return2 = "";
       $sth->bind_param_inout(":p6", \$return1, 100);
       $sth->bind_param_inout(":p7", \$return2, 100);
       #$sth->execute() || die new AGG_Exception(-message => '2.3', -details => 'BEGIN
   link_que_mod_pkg.add_resource(:p1, :p2, :p3, :p4, :p5, :p6, :p7); END;: $DBI::errstr');

       $sth->execute();
   }

   The error we are getting is as follows:

   Execution of stored procedure failed: ORA-06550: line 5, column 41:
   PLS-00561: character set mismatch on value for parameter 'P_RES_ID'
   ORA-06550: line 5, column 11:
   PL/SQL: Statement ignored (DBD ERROR: error possibly near <*> indicator at char 98 in '
   link_que_mod_pkg.add_resource(<*>:p1, :p2, :p3, :p4, :p5, :p6, :p7);

   :p1 references P_RES_ID, which I believe is getting filled with the garbage <*>.

   We have no idea how to get rid of the <*> or why it is even being inserted. We've tried several
   different
   ways to execute this to no avail. Any help at this point would be greatly appreciated. We did see in
   the
   dbd/dbi mail group there was a possible error that may pertain to this, but it didn;t exactly apply.

   Thank You,

   Paul Rowe
   Sr. Engineer
   Gartner
   Strategic Technology Group (STG)
   Tel: +1 716 633 0720 x217
   Cell: +1 203 918 2847
   Fax: +1 716 633 9506
   E-mail: paul.rowe@gartner.com
   www.gartner.com
   80 Holtz Drive
   Cheektowaga, NY 14225-1470

----- End forwarded message -----

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.sqlserver.server)
  • Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... having executing Sysbase stored procedures via JDBC. ... stored procedure which contains DDL and with AutoCommit set to false I ... The explanation for this behaviour I have found is that the JDBC ... I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Sybase, JDBC, AutoCommit, DDL IN TRAN
    ... > having executing Sysbase stored procedures via JDBC. ... > stored procedure which contains DDL and with AutoCommit set to false I ... > The explanation for this behaviour I have found is that the JDBC ... > I need to be able to set AutoCommit to false and execute multiple ...
    (comp.lang.java.databases)
  • Re: Records lost in an ADOStoredProc
    ... Use a thread to fire off the stored procedures so that your application ... Let's suppose it updates ... > the CacheSize is set to 1; it is worse when I increase the CacheSize. ... > I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Re: call Stored procedure with no params
    ... All stored procedures are exposed as methods of the Connection ... This means you can execute a procedure "Fred" like this: ... so you have parameters (most SPs do). ... Where 5522.22 is a non-string parameter value. ...
    (microsoft.public.data.ado)