ID: 13454
Updated by: [EMAIL PROTECTED]
-Summary: odbc_execute gives "SQL data type out of range" error for
store procedure
Reported By: [EMAIL PROTECTED]
-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] [EMAIL PROTECTED]
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
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, visit: http://www.php.net/unsub.php
