Skip to content
Advertisement

ORACLE SQL How to use custom function iside insert cte

I am trying to use function inside insert SQL, but I am getting error ORA-32034. Looks like that I couldn’t access this function in the cte. Maybe someone can help?

Advertisement

Answer

If the query containing the PL/SQL declaration section is not the top level query, the top-level query must include the WITH_PLSQL hint. Without this hint, the statement will fail to compile

This says documentation. So in this case you will probably need:

dbfiddle with similiar table

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement