tag:blogger.com,1999:blog-8185384792158425670.post7777597928143228387..comments2024-03-28T07:25:40.651-07:00Comments on APEX stuff in one place: ORACLE 19c bug in cursor expressionSLinohttp://www.blogger.com/profile/09438773517445280187noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8185384792158425670.post-10480332226107502532022-04-21T10:40:04.148-07:002022-04-21T10:40:04.148-07:00I don't know the limit but i'm tried with ...I don't know the limit but i'm tried with rownum < 20000 and it's fixing the problem too.Anonymoushttps://www.blogger.com/profile/04537461251907474740noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-44270676387808319292022-04-21T10:34:37.366-07:002022-04-21T10:34:37.366-07:00If you know the limit number of rows returned, you...If you know the limit number of rows returned, you can use a rownum limtation (where ROWNUM < 200 ) for each loopsAnonymoushttps://www.blogger.com/profile/04537461251907474740noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-12142457569304629752020-09-01T23:54:29.961-07:002020-09-01T23:54:29.961-07:00We still did not receive any updates on this from ...We still did not receive any updates on this from Oracle so not sure. Workaround would be to create a JSON manually. or try to force 12c execution plan on your 19c database. In both cases I would try to see if they fixed it with latest patches. The above should help in case Oracle has not addresses this yet. ;)SLinohttps://www.blogger.com/profile/09438773517445280187noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-5081325327350319852020-09-01T11:08:21.256-07:002020-09-01T11:08:21.256-07:00Is there any update on this issue? Is it a bug and...Is there any update on this issue? Is it a bug and what actions have been taken to solve this problem?<br /><br />Appreciate your help.<br /><br />Thanks,<br />SudhaKshatrihttps://www.blogger.com/profile/02838024289459855157noreply@blogger.comtag:blogger.com,1999:blog-8185384792158425670.post-84935991764116007362019-10-15T05:20:16.068-07:002019-10-15T05:20:16.068-07:00Thanks for taking the time to raise a ticket with ...Thanks for taking the time to raise a ticket with support, Lino.Stevenhttps://www.blogger.com/profile/08752077872490863192noreply@blogger.com