By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE PROCEDURE example1 IS
BEGIN
DBMS_OUTPUT.PUT_LINE('A');
END;
/
CREATE PACKAGE package_example IS
PROCEDURE example1;
END;
/
CREATE PACKAGE BODY package_example IS
PROCEDURE example1 IS
BEGIN
DBMS_OUTPUT.PUT_LINE('B');
END;
END;
/
SELECT object_name, object_type
FROM USER_OBJECTS
WHERE OBJECT_NAME IN ('EXAMPLE1', 'PACKAGE_EXAMPLE');
| OBJECT_NAME | OBJECT_TYPE |
|---|---|
| EXAMPLE1 | PROCEDURE |
| PACKAGE_EXAMPLE | PACKAGE |
| PACKAGE_EXAMPLE | PACKAGE BODY |
BEGIN
DBMS_OUTPUT.ENABLE();
example1;
END;
/
1 rows affected
dbms_output:
A
BEGIN
DBMS_OUTPUT.ENABLE();
package_example.example1;
END;
/
1 rows affected
dbms_output:
B
DROP PROCEDURE example1;
BEGIN
DBMS_OUTPUT.ENABLE();
example1;
END;
/
ORA-06550: line 3, column 3:
PLS-00201: identifier 'EXAMPLE1' must be declared
ORA-06550: line 3, column 3:
PL/SQL: Statement ignored
BEGIN
DBMS_OUTPUT.ENABLE();
package_example.example1;
END;
/
1 rows affected
dbms_output:
B