At 04:33 AM 31-05-01 +0000, you wrote:

>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,
Please post the ddl for your stored procedure.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________