Learn How to Execute a Procedure in Toad For Oracle

Learn How to Execute a Procedure in Toad For Oracle

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In this tutorial, you will learn how to execute a procedure in Toad for Oracle.

Follow these steps to execute a procedure in Toad for Oracle.

  1. Open the Toad for Oracle.
  2. Connect to the Database.
  3. Click on the menu Database > Schema Browser.
  4. In the Schema Browser, click on the Procedures Tab or drop-down menu.
  5. List of Procedures will be displayed. Then select the Procedure you want to execute and do the right click on it.
  6. From the shortcut menu, select Execute Procedure to execute the procedure.
  7. A window will pop-up as shown below.

execute stored procedure in toad

  1. Set the parameter's value in the arguments section or set directly into the code section below. For example, for parameter P_EMPNO specify a number value instead of NULL.
  2. Then click on OK to execute. You can also copy the code displayed in Code section of the window and paste it into the SQL editor and execute.

Below is the example how you can execute the procedure copied from the above window in Toad SQL editor. There you can see the output also using SET SERVEROUTPUT ON command.

SET SERVEROUTPUT ON;
DECLARE 
P_EMPNO NUMBER;

BEGIN 
P_EMPNO := NULL;

VINISH.PEMP ( P_EMPNO );
COMMIT; 
END;

Output:

PL/SQL procedure successfully completed.

See also: