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
