Status: Closed (View Workflow)
Request via email
I've ported used defined aggregate functions (UDAF) to sql_mode=ORACLE.
Earlier UDAF did note work with sql_mode=ORACLE.
Can you please document this?
Syntactically, an UDAF for sql_mode=ORACLE is
a normal PL/SQL function, with:
1. a FETCH GROUP NEXT ROW statement
2. an EXCEPTION WHEN NO_DATA_FOUND
Note, SQL/PSM-style CONTINUE HANDLER can be used instead of #2 as well,
however we probably don't want to advertise this in the manual.
Please use Oracle's EXCEPTION in examples.
Please find examples in tests in this commit:
Note, Oracle has UDAFs, but they are implemented using a
different syntax. We'll probably implement Oracle native
syntax for UDAFs later.