Subject | Re: [firebird-php] Firebird stored procedures |
---|---|
Author | moscow@cix.co.uk |
Post date | 2003-10-16T11:07Z |
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---------
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