Tag: Oracle Stored Procedure

Is it possible to call a Stored Procedure within the OraCmd ? Yes, You can. For example, you have a Oracle stored procedure “test_procedure”, create or replace procedure test_procedure is begin delete from employees where employee_id < 100; end test_procedure; In OraCmd, you can enter “call test_procedure();” to execute it. OraCmd> call test_procedure();   You…