--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> Leonardo Cosmai wrote:
> Leo,
>
> Use "left join" instead of "inner join" to join with procedures.
>
> see you !
>
> --
> Alexandre Benson Smith

Thanx for the hint, but nothing changes. I change my code like this:

SELECT * FROM STORE_PROCEDURE(?,?)

where STORE_PROCEDURE:

FOR SELECT DOC10.DOC10CODE
FROM
DOC00
INNER JOIN DOC10 ON (DOC10.DOC10DOC0 = DOC00.DOC00CODE)
INNER JOIN TAB00 ON (DOC10.DOC10TREC = TAB00.TAB00CODE AND
TAB00.TAB00TREC = 'TSTO')
WHERE
DOC00.DOC00ANA0 = :ANA00CODE
AND DOC00.LOG00FL00 = ' '
AND DOC10.LOG00FL00 = ' '
AND DOC10.DOC10ANIN <= :DOC10ANNO
AND (DOC10.DOC10ANFN >= :DOC10ANNO OR DOC10.DOC10ANFN IS NULL)
AND (TAB00.TAB00FL01 = '1' OR TAB00.TAB00FL04 = '1')
ORDER BY
DOC10CODE
INTO
:DOC10CODE
DO BEGIN
SUSPEND;
END

as you can see this is a really simple store procedure, but the error
appears randomly

Thanx
Ciao
L.