Stocated procedures and php
Posted on 2002-05-10
I have a stocated procedure in interbase and i want to execute this procedure with php.
What i actually did is that i execute the procedure but i can't acces the result that the procedure is returning.
I have tried this:
$sql_stat = 'execute procedure get_trn_id RETURNING_VALUES :var';
$res = ibase_query($dbh, $sql_stat);
the result should be in the variable 'var' but i get an error message looking like this:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 29
Statement: EXECUTE PROCEDURE get_trn_id RETURNING_VALUES :sumb
So, help please!!