MaxDB 7.6.00.16. SQLDBC 7.6.00.12. DBD-MaxDB-7.5.00.32 (original version
from SAP)
create function test(p integer) returns smallint as
BEGIN
return 1;
END;
my $dbi = DBI->connect("dbi:MaxDB:maxdb/DCDB?unicode=true", "reg",
"123") or die "connecting: $DBI::errstr";
my $sth = $dbi->prepare("select REG.test(?) quant from dbadmin.dual") or
die "preparing: $DBI::errstr";
$sth->bind_param(1,153);
$sth->execute or die "executing: $DBI::errstr";
while(my $hash_ref = $sth->fetchrow_hashref) {
my $id = $hash_ref->{QUANT};
print "$id\n";
}
$sth->finish;
DBD::MaxDB::st execute failed: Numeric overflow for parameter/column (1)
at ./test.pl line 17.
executing: Numeric overflow for parameter/column (1) at ./test.pl line 17.
<html><head><meta http-equiv="Content-Type" content="text/html;
charset=utf-8"></head><body><PRE><PLAINTEXT>SQLDBC 7.6.
0 BUILD 012-121-102-632 Jul 18 2005 22:15:53
--- THREAD 1 --- 2005-09-29 15:47:19.780592 ---
2005-09-29 15:47:19.780787 [0x0xa183a30]
SERVERNODE: 'maxdb'
SERVERDB : 'DCDB'
USER : 'REG'
CONNECT PROPERTIES: (1 entry)
KEY: 'UNICODE' VALUE: 'true'
CONNECT COMMAND: 'CONNECT ? IDENTIFIED BY ? SQLMODE INTERNAL'
SESSION ID: 1
OK
::SET AUTOCOMMIT ON 2005-09-29 15:47:19.800304 [0x0xa183a30]
::PARSE 'SQLCURS_2' 2005-09-29 15:47:19.800908 [0x0xa18be68]
SQL COMMAND:'select REG.test(?) quant from dbadmin.dual'
PARSE ID: 00525744 00000301 54002C00 [1]
PARAMETERS:
I T L P IO N
1 FIXED 10 255 IN ''
COLUMNS:
I T L P N
2 FIXED 5 0 'QUANT'
::BIND PARAM 2005-09-29 15:47:19.802798 [0x0xa18be68]
I T AT L I D P
1 ASCII T 4 0x0A18C1BC 0x0A18C1C8 0x00000000
::EXECUTE 'SQLCURS_2' 2005-09-29 15:47:19.802900 [0x0xa18be68]
PARSE ID: 00525744 00000301 54002C00 [1]
SQL COMMAND: 'select REG.test(?) quant from dbadmin.dual'
INPUT PARAMETERS:
APPLICATION
I T AT L I DATA
SQL ERROR :
CODE : -10811
MESSAGE : Numeric overflow for parameter/column (1)
1 ASCII T 4 NTS '153' ***OVERFLOW ***
::CLOSE CONNECTION 2005-09-29 15:47:19.804778 [0x0xa183a30]
::EXECUTE DBS 'SQLCURS_1' 2005-09-29 15:47:19.804842 [0x0xa181880]
SQL COMMAND : 'ROLLBACK WORK RELEASE'
::RELEASE CONNECTION 2005-09-29 15:47:19.805993 [0x0xa183a30]
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
