I'm building an application in Oracle APEX and need some help implementing program logic and business rules that require more complexity than just declarative SQL.

Specifically, I have situations where I need to implement things like:

• Loops to process…

I am trying to understand how to use multiple procedures in APEX SQL script. First I don't really need stored procedure, but not sure how to declare simple procedure in APEX SQL script. So this is my attempt:

create or replace procedure test1 as
b…