[PHP-DEV] Bug #13445: odbc_execute gives "SQL data type out of range" error for store procedure From: gordonl <email protected>
Date: 09/25/01

From: gordonl <email protected>
Operating system: mandrake linux 2.15
PHP version: 4.0.4pl1
PHP Bug Type: ODBC related
Bug description: odbc_execute gives "SQL data type out of range" error for store procedure

I am going to an informix 9.3 server and the following code works:

$ce_notes ="sfasdfasdfsadfsadfasdfasdf";
$sql = "insert into call_extension(ce_activity,ce_callresult,ce_notes)
values (" . $ce_activity . ",3211664,?);";
   $stmt = odbc_prepare ($crs,$sql );
   $sqldata = array ($ce_notes);
   $r = odbc_execute ($stmt, $sqldata);

they following code fails:

$sql = "execute procedure
web_cr_update(?,'ADD',1312,4748999,17057,'2001-09-25
15:34:16.000','2001-09-25 15:34:16',0,277,null,0,null,14999)";
   $stmt = odbc_prepare ($crs,$sql );
   $sqldata = array ($ce_notes);
   $r = odbc_execute ($stmt, $sqldata);

with the following error:

Warning: SQL error: [Informix][Informix ODBC Driver]SQL data type out of
range., SQL state S1004 in SQLExecute in
/home/httpd/html/followup/calladd.php on line 65

Note: The value in $ce_notes is the same in each case and the line number
refers to odbc_execute line.

It also fails when I try:

$sql = "execute procedure web_filter_modify(?,14999,1312)";
....

Both stored procedures work within a c++ program. 

-- 
Edit bug report at: http://bugs.php.net/?id=13445&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>