[oaktable] ORA-64630 "unsupported use of SQL macro: use of SQL macro inside WITH clause is not supported"

  • From: Randolf Eberle-Geist <randolf.geist@xxxxxxxxxxxxxxxxxxxxx>
  • To: oaktable@xxxxxxxxxxxxx
  • Date: Mon, 22 Feb 2021 18:59:32 +0100

Dear Oakies,

I have a customer on 19c that wants to make use of "SQL Macros". In principle it's working fine for their purpose and they are happy, but they hit above limitation, which means they would need rewrite a lot of queries making extensive use of WITH clauses if they want to move to "SQL Macros".

I've did a quick test setting "_with_subquery" to "inline" but that gives the same error message when using them inside a WITH clause.

Does anyone already have experience in that regard what could be a useful workaround?

Thanks!

Randolf

Other related posts: