How to manually execute a stored procedure in Oracle?

6 months ago

1 minute

To manually execute a stored procedure in Oracle, you can follow these steps:

Open the SQL development tool, such as SQL Developer or Toad.
Call the stored procedure using the following syntax:

BEGIN
  procedure_name(parameter1, parameter2, ...);
END;

Here, procedure_name refers to the name of the stored procedure, while parameter1, parameter2, … refer to the parameters of the stored procedure.

Executing the above code will manually run the stored procedure.

For example, if there is a stored procedure named my_procedure that accepts an integer parameter, you can manually execute it using the following code:

BEGIN
  my_procedure(123);
END;

This way you can manually execute the stored procedure.