BEGIN
sys.DBMS_OUTPUT.put_line (DBMS_ASSERT.schema_name ('HR'));
END; HR
BEGIN
sys.DBMS_OUTPUT.put_line (DBMS_ASSERT.sql_object_name ('EMPLOYEES'));
END; ORA-44002: invalid object name ORA-06512: at "SYS.DBMS_ASSERT", line 417 ORA-06512: at "SYS.DBMS_ASSERT", line 412 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-44002
BEGIN
sys.DBMS_OUTPUT.put_line (DBMS_ASSERT.qualified_sql_name ('HR.EMPLOYEES'));
END; HR.EMPLOYEES
BEGIN
sys.DBMS_OUTPUT.put_line (DBMS_ASSERT.schema_name ('HR'));
END; HR
BEGIN
sys.DBMS_OUTPUT.put_line (DBMS_ASSERT.schema_name ('WHO_ME'));
END; ORA-44001: invalid schema ORA-06512: at "SYS.DBMS_ASSERT", line 355 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-44001
BEGIN
DBMS_OUTPUT.put_line (
DBMS_ASSERT.sql_object_name (
'EMPLOYEES, (SELECT * FROM ALL_USERS) u'));
END; ORA-44002: invalid object name ORA-06512: at "SYS.DBMS_ASSERT", line 415 ORA-06512: at "SYS.DBMS_ASSERT", line 320 ORA-06512: at "SYS.DBMS_ASSERT", line 260 ORA-06512: at "SYS.DBMS_ASSERT", line 391 ORA-06512: at line 2 ORA-06512: at "SYS.DBMS_SQL", line 1721More Details: https://docs.oracle.com/error-help/db/ora-44002