I have a SQL:
insert into A select something from B where condition='xyz';
If I execute this SQL inside "SQL Commends" on apex.oracle.com (currently 22.1), it works perfectly fine, BUT if I put it inside a procedure:
create or replace procedure myproc as
begin
insert into A select something from B where condition='xyz';
end
/
It compiled, but when "exec myproc", I got:
ORA-00900: invalid SQL statement
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 847
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658
ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_220100", line 833
ORA-06512: at "APEX_220100.WWV_FLOW_DYNAMIC_EXEC", line 1903
This is way beyond comprehension, please help, help, help!
Thank you so much!