Subject | Re: [Firebird-Java] JayBird Stored Procedures Support |
---|---|
Author | Ray Holme |
Post date | 2003-03-01T13:35:26Z |
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
goes
to EOF immediately
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
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
goes
to EOF immediately
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/