Storing PL/SQL procedure in the Database : Procedure « Function Procedure Packages « Oracle PL/SQL Tutorial






create [or replace]
procedure procedure name (parameters)
is
     ...
    begin
        ...
    end;
SQL>
SQL> create or replace procedure p_print(i_str1 VARCHAR2 :='hello',
  2                    i_str2 VARCHAR2 :='world',
  3                    i_end VARCHAR2  :='!' )
  4  is
  5  begin
  6       DBMS_OUTPUT.put_line(i_str1||','||i_str2||i_end);
  7  end;
  8  /

Procedure created.

SQL>








27.5.Procedure
27.5.1.Procedures
27.5.2.A procedure block.
27.5.3.Wrapping a task into a procedure
27.5.4.Storing PL/SQL procedure in the Database
27.5.5.Creating stored procedures
27.5.6.Execute a procedure
27.5.7.Demonstration of a nested procedure block
27.5.8.Create or replace a procedure
27.5.9.Calling a Procedure
27.5.10.Pass ROWTYPE to a procedure
27.5.11.Insert debug line to the stored procedure with DBMS_OUTPUT.PUT_LINE
27.5.12.Listing Stored Procedure Information
27.5.13.Decrease salary with user procedure
27.5.14.Forward Referencing