Hello,
after upgrade to 12c we have encountered a problem with following sql:
insert into test
(
id,
ruw_number
)
values
(
1,
rownum
);
Above statment will produce:
SQL Error: ORA-00976: Specified pseudocolumn or operator not allowed here.
00976. 00000 - "Specified pseudocolumn or operator not allowed here."
*Cause: LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or
CONNECT_BY_ISCYCLE was specified at an illegal location.
*Action: Remove LEVEL, PRIOR, ROWNUM, CONNECT_BY_ROOT, CONNECT_BY_ISLEAF or
CONNECT_BY_ISCYCLE.
I have a bunch of old SQLs that are using same method and i was wondering if there is a work-around?
Thank you!