Subject | Firebird stored procedures |
---|---|
Author | moscow@cix.co.uk |
Post date | 2003-10-16T10:07Z |
I'm using 1.0.3 with php 4.3.2, but am unable to run a stored procedure
without error.
My code is:
<?php include "dbconn.php";
$sql = "execute procedure org_chart";
$result = ibase_query($conn, $sql);
?>
Although I am able to execute the org_chart procedure directly within
ibexpert (it requires no parameters - and some may recognise it as being
in the firebird download examples), each time I try to run the above, I
get a warning for a message length error (encountered 0, expected 93).
The $conn is correct, as I can do a simple table query without problems -
it just seems to be the procedure that causes errors.
Any ideas?
Terry Riley
without error.
My code is:
<?php include "dbconn.php";
$sql = "execute procedure org_chart";
$result = ibase_query($conn, $sql);
?>
Although I am able to execute the org_chart procedure directly within
ibexpert (it requires no parameters - and some may recognise it as being
in the firebird download examples), each time I try to run the above, I
get a warning for a message length error (encountered 0, expected 93).
The $conn is correct, as I can do a simple table query without problems -
it just seems to be the procedure that causes errors.
Any ideas?
Terry Riley