Subject Re: [Firebird-Java] JayBird Stored Procedures Support
Author Ray Holme
The best way I have found to facilitate stored
procedure's in Jaybird or even in raw SQL depends on
whether your procedures have output or not.

1) if not - "execute procedure ...(...)" works fine

2) if so - " select ... from ...()" works fine too
- however if your procedure returns just one row
- add a "suspend" statement before it exits so you
get back the singleton row select - otherwise it
to EOF immediately

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more