Subject problems with joins involving stored procedures
Author gbien@intekom.co.za
Hi,

Are there any known problems using joins involving
stored procedures in IBO 3.6?? The following sql
(and others) causes IBConsole (vers 1.0.0.326) and
ib_wisql to hang and the server to terminate
abnormally. Whereas they work ok with some other tools.

SELECT
C.WIDECUSTOMERID,
A.*
FROM
AR_AGING('%','1/1/2001') A INNER JOIN CUSTOMER C ON
A.CUSTOMERID = C.CUSTOMERID
ORDER BY 1


Geoff