Trying to change some simple code in a stored procedure but unable to compile and save… thought i must have made a silly mistake but then realised I couldnt even compile and save with no changes… to a routine that is running with no issues at all.
I seem to have narrowed it down to a few string related functions… using concat / substr and || tends to result in this error.
But even more bizzarely if you comment out offending code the issue persists!
Before you critique my code - I stripped down bit by bit (kind of a binary search) to figure out the triggering issue(s) and then dumbified my code to do nothing and be able to be so simple it does not need any database objects etc. and essentially does nothing… remember the code is not the issue ;)
code snippet below… if you remove the || from the commented out code the error disappears…
At 2am this morning I gave up :)
BTW: running Oracle Apex as a Service in OCI and currently on patch set / version 24.1.7 … with this service/environment it seems we have no control over the patch level upgrades. (as in I can see there are release notes for subsequent patches but in the environment administration it says there are no updates/upgrades available).
Thanks in advance to anyone who may have any clues here…
regards
charles
create or replace procedure TESTFIGUREOUTSYNTAX
as
begin
for cursor_record in (select '1' somenumber from dual ) loop
null;
end loop;
-- 'this is absolute nonsense'||
end TESTFIGUREOUTSYNTAX;
/
