We are going to create a simple procedure in Oracle, which will print a statement.
CREATE OR REPLACE PROCEDURE procedureName IS BEGIN DBMS_OUTPUT.PUT_LINE('You have successfully executed the procedure!'); END;
To execute or call the above created procedure in Oracle Application express use the following statement.
BEGIN procedureName; END;
Below is the screenshot:
Create and execute procedure in oracle application express edition | Screenshot |
You can also download the complete exercise with code from Git .
No comments:
Post a Comment