----- 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 -----
