Creating Procedures Using SQL Explorer
To create a procedure:
- In the context tree, select the schema that you want the new procedure to be in.
- 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;
- 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.