Bug #13454 Updated: odbc_execute gives "SQL data type out of range" error for store procedure

ID: 13454 Updated by: kalowsky@php.net -Summary: odbc_execute gives "SQL data type out of range" error for store procedure Reported By: gordonl@tts-sf.com -Status: Open +Status: Duplicate Bug Type: ODBC related PHP Version: 4.0.4pl1 New Comment: Please read the bug commiting rules. One report per bug please. Putting the same bug in more than once won't get it resolved any quicker. Previous Comments: ------------------------------------------------------------------------ [2001-09-26 11:27:19] gordonl@tts-sf.com 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 this bug report at http://bugs.php.net/?id=13454&edit=1