Join & Functions (2)

Hi,
 about the problem discussed in the previous mail ("Join & Functions) we 
discovered that the behaviuor of the kernel changes in relation with the number 
of the rows retrieved.
In fact the following query works:

SELECT D.*
FROM DOCUMENT D
left join DOCUMENT_VERSION V on (D.K_DOCUMENT = V.E_DOC_K_DOCUMENT)
WHERE D.K_DOCUMENT IN(
SELECT E.K_DOCUMENT
FROM DOCUMENT E
WHERE 
rownum<=18 and                                          /*  
<-------------------- ROWNUM */
(1=hasPermOnDocument(
E.K_DOCUMENT,
E.E_DOC_TYP_K_DOCUMENT_TYPE,
to_number('1'),
to_number('2'),
to_date('15/11/2002','dd/mm/yyyy'),
to_number('1'))))
ORDER BY D.K_DOCUMENT

whereas increasing rownum we get "Move errror".
So we think that is due to some parameter, but can't find the right one.

We can attach vTrace of both queries (the one with 'rownum<=18' and the one 
with 'rownum<=19') if you need more information.

Thanks again
Fabio Pinotti