Oracle Live SQL - Script: PLW-05011

Statement 1

ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'

Statement processed.

Statement 2

CREATE OR REPLACE PACKAGE foo IS 
BEGIN 
PROCEDURE bar; 
END foo;

Errors: PACKAGE FOO
Line/Col: 2/1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:

   end function pragma procedure subtype type <an identifier>
   <a double-quoted delimited-identifier> current cursor delete
   exists prior
The symbol "BEGIN" was ignored.

More Details: https://docs.oracle.com/error-help/db/ora-24344

Statement 3

CREATE OR REPLACE PACKAGE BODY foo IS 
BEGIN 
     
PRAGMA INLINE (sub, 'YES'); 
PROCEDURE sub IS 
BEGIN 
    dbms_output.put_line('sub'); 
END sub; 
 
PROCEDURE bar IS 
BEGIN 
    dbms_output.put_line('bar'); 
	sub; 
END bar; 
 
END foo;

Errors: PACKAGE BODY FOO
Line/Col: 5/1 PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   continue close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge pipe purge
   json_exists json_value json_query json_object json_array
The symbol "declare" was substituted for "PROCEDURE" to cont
Line/Col: 16/1 PLS-00103: Encountered the symbol "END" when expecting one of the following:

   begin function pragma procedure

More Details: https://docs.oracle.com/error-help/db/ora-24344

Statement 4

SELECT * FROM user_errors


NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
FOO PACKAGE 1 2 1 PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following:

   end function pragma procedure subtype type <an identifier>
   <a double-quoted delimited-identifier> current cursor delete
   exists prior
The symbol "BEGIN" was ignored.
ERROR 103
FOO PACKAGE BODY 1 5 1 PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following:

   ( begin case declare exit for goto if loop mod null pragma
   raise return select update while with <an identifier>
   <a double-quoted delimited-identifier> <a bind variable> <<
   continue close current delete fetch lock insert open rollback
   savepoint set sql execute commit forall merge pipe purge
   json_exists json_value json_query json_object json_array
The symbol "declare" was substituted for "PROCEDURE" to cont ERROR 103
FOO PACKAGE BODY 2 16 1 PLS-00103: Encountered the symbol "END" when expecting one of the following:

   begin function pragma procedure
ERROR 103

3 rows selected.

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
FOO	PACKAGE	1	2	1	PLS-00103: Encountered the symbol "BEGIN" when expecting one of the following: end function pragma procedure subtype type <an identifier> <a double-quoted delimited-identifier> current cursor delete exists prior The symbol "BEGIN" was ignored.	ERROR	103
FOO	PACKAGE BODY	1	5	1	PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: ( begin case declare exit for goto if loop mod null pragma raise return select update while with <an identifier> <a double-quoted delimited-identifier> <a bind variable> << continue close current delete fetch lock insert open rollback savepoint set sql execute commit forall merge pipe purge json_exists json_value json_query json_object json_array The symbol "declare" was substituted for "PROCEDURE" to cont	ERROR	103
FOO	PACKAGE BODY	2	16	1	PLS-00103: Encountered the symbol "END" when expecting one of the following: begin function pragma procedure	ERROR	103

Statement 5

ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'

Statement processed.

Statement 6

CREATE OR REPLACE PACKAGE foo IS 
PROCEDURE bar; 
END foo;

Warning: PACKAGE FOO
Line/Col: 1/1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used

More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 7

CREATE OR REPLACE PACKAGE BODY foo IS 
     
PRAGMA INLINE (sub, 'YES'); 
PROCEDURE sub IS 
BEGIN 
    dbms_output.put_line('sub'); 
END sub; 
 
PROCEDURE bar IS 
BEGIN 
    dbms_output.put_line('bar'); 
	sub; 
END bar; 
 
END foo;

Warning: PACKAGE BODY FOO
Line/Col: 3/1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls

More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 8

SELECT * FROM user_errors


NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
FOO PACKAGE BODY 1 3 1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls WARNING 5011
FOO PACKAGE 1 1 1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used WARNING 5018

2 rows selected.

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
FOO	PACKAGE BODY	1	3	1	PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls	WARNING	5011
FOO	PACKAGE	1	1	1	PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used	WARNING	5018

Statement 9

ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'

Statement processed.

Statement 10

CREATE OR REPLACE PACKAGE foo IS 
PRAGMA INLINE (sub, 'YES'); 
PROCEDURE bar; 
END foo;

Warning: PACKAGE FOO
Line/Col: 1/1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used
Line/Col: 2/1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls

More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 11

CREATE OR REPLACE PACKAGE BODY foo IS 
     
PROCEDURE sub IS 
BEGIN 
    dbms_output.put_line('sub'); 
END sub; 
 
PROCEDURE bar IS 
BEGIN 
    dbms_output.put_line('bar'); 
	sub; 
END bar; 
 
END foo;

Package Body created.

Statement 12

SELECT * FROM user_errors


NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
FOO PACKAGE 1 1 1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used WARNING 5018
FOO PACKAGE 2 2 1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls WARNING 5011

2 rows selected.

NAME	TYPE	SEQUENCE	LINE	POSITION	TEXT	ATTRIBUTE	MESSAGE_NUMBER
FOO	PACKAGE	1	1	1	PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used	WARNING	5018
FOO	PACKAGE	2	2	1	PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls	WARNING	5011

Statement 13

ALTER SESSION SET PLSQL_WARNINGS = 'ENABLE:ALL'

Statement processed.

Statement 14

CREATE OR REPLACE PACKAGE foo IS 
PROCEDURE bar; 
END foo;

Warning: PACKAGE FOO
Line/Col: 1/1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used

More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 15

CREATE OR REPLACE PACKAGE BODY foo IS 
     
PRAGMA INLINE (sub, 'YES'); 
PROCEDURE sub; 
 
PROCEDURE bar IS 
BEGIN 
    dbms_output.put_line('bar'); 
	sub; 
END bar; 
 
PROCEDURE sub IS 
BEGIN 
    dbms_output.put_line('sub'); 
END sub; 
 
END foo;

Warning: PACKAGE BODY FOO
Line/Col: 3/1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls

More Details: https://docs.oracle.com/error-help/db/ora-20001

Statement 16

SELECT * FROM user_errors


NAME TYPE SEQUENCE LINE POSITION TEXT ATTRIBUTE MESSAGE_NUMBER
FOO PACKAGE 1 1 1 PLW-05018: unit FOO omitted optional AUTHID clause; default value DEFINER used WARNING 5018
FOO PACKAGE BODY 1 3 1 PLW-05011: pragma INLINE for procedure 'SUB' does not apply to any calls WARNING 5011

2 rows selected.

PLW-05011

Additional Information