Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Validation of recursive function call fails

58993Jul 8 2004 — edited Jul 9 2004
We want to use a call to a recursive function from a HTMLDB application. It should be used in a page region to generate a query string ("PL/SQL function body returning SQL query"). Everything works fine with a call to a non-recursive function. The recursive function also works fine when called from SQL+.
After pressing "Apply changes" on "HTML DB Home>Builder - Application 148>Page Definition>Edit Page Region"-page I get the following error message after a long delay:

Function returning SQL query: Query cannot be parsed within the Builder. If you believe your query is syntactically correct, check the ''generic columns'' checkbox below the region source to proceed without parsing
(ORA-00600: internal error code, arguments: [kohdtf048], [], [], [], [], [], [], [])

I assume that the validation routine follows the recursion until the memory limit is reached.
Please give me a hint how to solve this problem.

DB version: 10.1.0.2.0
HTMLDB version: 1.5.0.00.33
running on Win2000 server
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2004
Added on Jul 8 2004
3 comments
322 views