replace a procedure : Procedure Definition « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Procedure Definition

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>








Related examples in the same category

1.Creat an empty procedure
2.Create a stored procedure and how to call it.
3.Define procedure to insert data
4.Define and call procedure
5.Create procedure with authid
6.Create a stored procedure with authid
7.Mutually exclusive local subprograms.
8.A forward declaration.
9.Inner procedure
10.Save calculation result to a table in procedure
11.exception throwed out of the procedure
12.AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with user's or invoker's rights
13.Increase gift price
14.A local subprogram within a stored procedure
15.Overloaded local procedures: number and varchar2
16.Using all the default values
17.Forward Referencing
18.Mark procedure with authid current_user
19.Reference package variable in a procedure
20.Only manager can change the password