Overloaded local procedures: number and varchar2

    
SQL>
SQL> DECLARE
  2    
  3    PROCEDURE LocalProc(p1 IN NUMBER) IS
  4    BEGIN
  5      DBMS_OUTPUT.PUT_LINE('In version 1, p1 = ' ||p1);
  6    END LocalProc;
  7
  8    PROCEDURE LocalProc(p1 IN VARCHAR2) IS
  9    BEGIN
 10      DBMS_OUTPUT.PUT_LINE('In version 2, p1 = ' ||p1);
 11    END LocalProc;
 12  BEGIN
 13    
 14    LocalProc(12345);
 15
 16    
 17    LocalProc('abcdef');
 18  END;
 19  /
In version 1, p1 = 12345
In version 2, p1 = abcdef

PL/SQL procedure successfully completed.

SQL>

1.	Creat an empty procedure
2.	replace a procedure
3.	Create a stored procedure and how to call it.
4.	Define procedure to insert data
5.	Define and call procedure
6.	Create procedure with authid
7.	Create a stored procedure with authid
8.	Mutually exclusive local subprograms.
9.	A forward declaration.
10.	Inner procedure
11.	Save calculation result to a table in procedure
12.	exception throwed out of the procedure
13.	AUTHID clause in a CREATE PROCEDURE statement indicates that this procedure is being created with user's or invoker's rights
14.	Increase gift price
15.	A local subprogram within a stored procedure
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

Overloaded local procedures: number and varchar2 : Procedure Definition « Stored Procedure Function « Oracle PL / SQL

Related examples in the same category