| Al Partis 2004-06-25, 6:46 pm |
| Anyone? If no-one has an answer, can anyone point me in the right direction for finding an answer?
-----
How do I specify an output parameter in a prepared statement?
I'm calling a stored procedure on a remote DB2 database that takes two arguments: one input argument and one output argument. The stored proc returns a result set.
How do I specify the output parameter in my PHP code?
Here's what I have so far (I've tried numerous variations, but none of them work):
$rc = 99;
$args = array($client_nbr, ':$rc');
$query = "call WEB001SP (?, !)";
$pstmt = $db->prepare($query);
$rs = $db->execute($pstmt, $args);
This solution results in the following error statement from DB2:
[DB2 UDB]SQL0312 - Variable $RC not defined or not usable.
Any thoughts?
________________________________________
________________
Alan Partis
thundernet development group
|