Unsupported use of WITH clause
While helping out in the conversion of some MySQL SQL, I tried the WITH
clause inside a subquery for a multiple row INSERT
statement. I got a nasty surprise, it’s not supported. I got the following error:
FROM dual ) * ERROR at line 16: ORA-32034: unsupported USE OF WITH clause |
Consistent with how I’m updating old blog pages and posts, you can find the full explanation in the updated blog post on the WITH
clause. As Dominic commented, I got the syntax wrong and he’s got it for a single row subquery in the comment too. The blog page is updated with both a single and multiple row subquery.