At 01:47 AM 16/03/2005 +0000, you wrote:

>I guess my problem is trying to programmatically get the return
>value(s). I am new to the world of doing SP programming so I was
>expecting the values to be returned in a pseudo table format.

Well, how you get the return values back to an application depends entirely
on your data access interface. You can, for example, write an API
application that reads the XSQLDA structure (the XSQLVARs that you
previously prepared for the return values); but there are loads of
language-specific class interfaces that do this all this stuff for you and
let you access them through classes. IBExpert, for example, uses
FIBPlus; IB_SQL uses IB Objects...IBConsole uses Borland's IB components,
which aren't among the high flyers. For Java there is Jaybird; for .NET
there is the Firebird .NET provider...and so on.

My preference (overwhelming!) is IBO. For executable SPs I use IBO's
TIB_DSQL class, which takes a[n optionally parameterised] EXECUTE PROCEDURE
statement and returns an array of TIB_Column objects containing the return
values. Lightning quick.

./hb