
Resolving PL/SQL Procedure Names
DECLARE
PROCEDURE Swap
(n1 NUMBER,
n2 NUMBER)
IS
num1 NUMBER;
num2 NUMBER;
FUNCTION Balance
(bal NUMBER)
RETURN NUMBER
IS
x NUMBER := 10;
PROCEDURE Swap
(d1 DATE,
d2 DATE)
IS
BEGIN
NULL;
END;
PROCEDURE Swap
(b1 BOOLEAN,
b2 BOOLEAN)
IS
BEGIN
NULL;
END;
BEGIN
dbms_output.Put_line('The following raises an error');
-- swap(num1, num2); wrong number or types of arguments in call to 'SWAP'
RETURN x;
END balance;
BEGIN
NULL;
END swap;
BEGIN
NULL;
END;
/

0 comments:
Post a Comment