problems by executing DB2 stored procedures from PHP4
| From: | Jani Laakso | Date: | Fri, 09 Nov 2001 14:27:08 +0000 |
| Subject: | problems by executing DB2 stored procedures from PHP4 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14182@lists.php.net to get a copy of this message | ||
Hi,
I faced unexpected problems while trying to execute IBM DB2 stored
procedures from PHP4. Procedures include only in-type parameters and they do
work fine when executed from command line. When adding {} around the
callable statement, the procedure seemed to work but I got an error message:
Warning: SQL error: [IBM][CLI Driver][DB2/LINUX] SQL0171N The data type,
length or value of argument "6" of routine "PROCEDURE_NAME" is incorrect
after checking the parameters I found them to be correct. I wonder if anyone
else have had this kind of problems with DB2? I would appreciate of getting
help in this case.
Thanks,
Jani Laakso