Mega Code Archive
Replace a procedure
SQL>
SQL>
SQL> create or replace procedure my_proc as
2 begin
3 dbms_output.put_line ( 'Hello World' );
4 end my_proc;
5 /
Procedure created.
SQL>
SQL> EXEC my_proc();
Hello World
PL/SQL procedure successfully completed.
SQL>
SQL>