Possible Bug: Function Called Twice in Nested XML Queries

Hello Oracle Community,

I’m encountering an issue in Oracle SQL where a function (get_nextval) appears to be called twice when used within a nested XML query. I’m trying to determine if this behavior is expected or if it might be a bug.

Problem Description:

I have a PL/SQL function get_nextval that simply returns the next value of a sequence. When I use this function within an XMLFOREST in a nested query, it gets called twice, even though I expect it to be called only once. Here’s an example of my code:

Plsql

create sequence seq1;