Subject Re: Stored Procedures
Author pcam_again
--- In Firebird-Java@yahoogroups.com, "Roman Rokytskyy"
<rrokytskyy@a...> wrote:
> Hi,
>
> > The documentation / FAQ seem to indicate this is not supported
yet.
> >
> > Also if it is not supported yet around about how long until it
will
> > be supported ?
>
> We do not fully support escaped syntax for procedure calls (output
> parameters are not supported). However if you use native Firebird
> syntax, stored procedures are fully supported.
>
> Native Firebird syntax:
>
> EXECUTE PROCEDURE proc_name(?, ?, ?, ...) for executable procedures;
> SELECT * FROM proc_name(?, ?, ...) for selectable procedures.
>

Thanks for your reply.

Can you please give an example, with the procedure meta data
and the syntax.

I have tried both types and syntax and can not get it to work.
It can't get it to recognize the procedure parameters.

From,

Phill Cameron