How to create and execute procedure in oracle express edition?

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 .

Execute Oracle procedure using Toad

How to execute a procedure written in Oracle using Toad?

Below is the syntax to execute the stored procedure using Toad for Oracle tool.

Syntax: 

var <variable_name> refcursor
BEGIN
rocedure_name('<parameter1>','<parameter2>',:<variable_name>);

END;

print <variable_name>

e.g.
var result refcursor
BEGIN
proc_MyProcedure('jorvee',:result);
END;
print result 

	var result refcursor -- create a variable result
	BEGIN
	proc_myActivities('rashidjorvee',:result); -- name of the parameter and all input parameters, and variable result as a last parameter with prefix of colon(:).
	END;
	-- execution of procedure has been completed and result stored in the variable result.
	-- Now you have to print the variable result to see the output.
	print result -- write command print and then variable name to print the result.

view raw exec-procedure.sql hosted with ❤ by GitHub