The <*> is an indicator as to the location of the possible problem. This is
useful in large statements as it tells you which part the oracle error
refers to. 

If you want to see the data which is being passed to the stored proc then
you can use DBI->trace
(http://www.google.co.uk/search?hl=en&safe=off&q=DBI-%3Etrace&meta=) to let
you know. 

The error is being thrown inside the pl/sql procedure itself not the DBI!

I would

1.) Use DBI-> trace to find out exactly what you are passing to the
procedure
2.) Use sqlplus to call the procedure to replicate the problem

If sqlplus gives the same results then it is likely that you have a
character set issue (i.e. you are calling your function with data in a
difference character set to the instance it is running on or you NLS_LANG is
wrong).

If the results differ then I would try to create a simple and self contained
test case and post the pl/sql and DBI code along with a DBI level 9 trace to
the list. 

HTH

Andy

-----Original Message-----
From: Tim Bunce [mailto:[EMAIL PROTECTED] 
Sent: 18 November 2004 23:26
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: (Fwd) DBD:: Oracle Problems

----- Forwarded message from "Rowe,Paul" <[EMAIL PROTECTED]> -----

Delivered-To: [EMAIL PROTECTED]
X-SPF-Guess: pass (seems reasonable for [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Colon,Anthony" <[EMAIL PROTECTED]>
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:  [EMAIL PROTECTED]
   www.gartner.com
   80 Holtz Drive
   Cheektowaga, NY 14225-1470


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

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________


__________________________
This email and any files transmitted with it are confidential and intended 
solely for the use of the individual or entity to whom they are addressed. The 
contents are confidential and may be privileged.
Any views or opinions expressed are those of the sender and may not reflect the 
views or opinions of the company and the company accepts no liability in 
respect thereof.
If you have received this email in error please notify [EMAIL PROTECTED] 
immediately.

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________

Reply via email to