Hello Myles,

v> What I'm having trouble with is the Delphi code to call the procedure
v> and handle the returned value. Any ideas there?
If you have a selectable SP then you could use any component that
works with SELECTs: TpFIBQuery for example. Note that the transaction
is not read-only, and the component doesn't auto-commit the
transaction (to let you get the value returned - don't forget to
commit it yourself after fetching). After executing the SQL, refer to
the returned data via FieldByName or Fields.


--
HTH
Best regards,
Pavel Menshchikov
http://www.ls-software.com