Creating Procedures Using SQL Explorer

To create a procedure:

  1. In the context tree, select the schema that you want the new procedure to be in.
  2. In the Database Hierarchy menubar, click (New) | Procedure. SQL Explorer opens a query tab and populates it with a skeleton procedure:
    CREATE PROCEDURE PROCEDURE1 (IN P_IN INTEGER, IN P_OUT INTEGER) AS
         P_OUT = P_IN;
    END_PROCEDURE
  3. Modify this as needed and then click Execute in the menubar to save the procedure.

To cancel the addition of a procedure, close the tab in which you are defining the procedure.