Subject Re: [firebird-php] Firebird stored procedures
Author moscow@cix.co.uk
Thank you, Milan

Though it did require 'select * from org_chart' to work.

However, even though it works, it isn't exactly intuitive, as that is also
the way one would request information from a view.

I'm too used to SQLServer, I guess!

Thanks again

Terry

----------Original Message---------

> moscow@... wrote:
>
> > 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?
>
> Try to 'select from org_chart' instead of executing it.
>
> HTH
>
> --
> Milan Babuskov
> http://fbexport.sourceforge.net