Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE PACKAGE package_name IS
  something NOT_A_DATATYPE;
END;
/
ORA-24344: success with compilation error

CREATE PACKAGE BODY package_name IS
  FUNCTION fnct RETURN NUMBER
  IS
  BEGIN
    RETURN 42;
  END;
END;
/
ORA-24344: success with compilation error

SELECT * FROM USER_ERRORS;


NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


PACKAGE_NAME
PACKAGE
1
2
13
PLS-00201: identifier 'NOT_A_DATATYPE' must be declared
ERROR
201

PACKAGE_NAME
PACKAGE
2
2
13
PL/SQL: Declaration ignored
ERROR
0

PACKAGE_NAME
PACKAGE BODY
1
1
14
PLS-00905: object FIDDLE_AOKPTOFYVVLFZIRVKWMT.PACKAGE_NAME is invalid
ERROR
905

PACKAGE_NAME
PACKAGE BODY
2
1
14
PLS-00304: cannot compile body of 'PACKAGE_NAME' without its specification
ERROR
304

PACKAGE_NAME
PACKAGE BODY
3
0
0
PL/SQL: Compilation unit analysis terminated
ERROR
0


SELECT *
FROM   ALL_ERRORS
WHERE  owner = USER
AND    type IN ( 'PACKAGE', 'PACKAGE BODY' );


OWNER
NAME
TYPE
SEQUENCE
LINE
POSITION
TEXT
ATTRIBUTE
MESSAGE_NUMBER


FIDDLE_AOKPTOFYVVLFZIRVKWMT
PACKAGE_NAME
PACKAGE
1
2
13
PLS-00201: identifier 'NOT_A_DATATYPE' must be declared
ERROR
201

FIDDLE_AOKPTOFYVVLFZIRVKWMT
PACKAGE_NAME
PACKAGE
2
2
13
PL/SQL: Declaration ignored
ERROR
0

FIDDLE_AOKPTOFYVVLFZIRVKWMT
PACKAGE_NAME
PACKAGE BODY
1
1
14
PLS-00905: object FIDDLE_AOKPTOFYVVLFZIRVKWMT.PACKAGE_NAME is invalid
ERROR
905

FIDDLE_AOKPTOFYVVLFZIRVKWMT
PACKAGE_NAME
PACKAGE BODY
2
1
14
PLS-00304: cannot compile body of 'PACKAGE_NAME' without its specification
ERROR
304

FIDDLE_AOKPTOFYVVLFZIRVKWMT
PACKAGE_NAME
PACKAGE BODY
3
0
0
PL/SQL: Compilation unit analysis terminated
ERROR
0

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
PACKAGE_NAME	PACKAGE	1	2	13	PLS-00201: identifier 'NOT_A_DATATYPE' must be declared	ERROR	201
PACKAGE_NAME	PACKAGE	2	2	13	PL/SQL: Declaration ignored	ERROR	0
PACKAGE_NAME	PACKAGE BODY	1	1	14	PLS-00905: object FIDDLE_AOKPTOFYVVLFZIRVKWMT.PACKAGE_NAME is invalid	ERROR	905
PACKAGE_NAME	PACKAGE BODY	2	1	14	PLS-00304: cannot compile body of 'PACKAGE_NAME' without its specification	ERROR	304
PACKAGE_NAME	PACKAGE BODY	3	0	0	PL/SQL: Compilation unit analysis terminated	ERROR	0

OWNER	NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
FIDDLE_AOKPTOFYVVLFZIRVKWMT	PACKAGE_NAME	PACKAGE	1	2	13	PLS-00201: identifier 'NOT_A_DATATYPE' must be declared	ERROR	201
FIDDLE_AOKPTOFYVVLFZIRVKWMT	PACKAGE_NAME	PACKAGE	2	2	13	PL/SQL: Declaration ignored	ERROR	0
FIDDLE_AOKPTOFYVVLFZIRVKWMT	PACKAGE_NAME	PACKAGE BODY	1	1	14	PLS-00905: object FIDDLE_AOKPTOFYVVLFZIRVKWMT.PACKAGE_NAME is invalid	ERROR	905
FIDDLE_AOKPTOFYVVLFZIRVKWMT	PACKAGE_NAME	PACKAGE BODY	2	1	14	PLS-00304: cannot compile body of 'PACKAGE_NAME' without its specification	ERROR	304
FIDDLE_AOKPTOFYVVLFZIRVKWMT	PACKAGE_NAME	PACKAGE BODY	3	0	0	PL/SQL: Compilation unit analysis terminated	ERROR	0