PL/SQL (MOSC)

MOSC Banner

DBMS_ASSERT.SQL_OBJECT_NAME documentation

edited Feb 7, 2019 5:15AM in PL/SQL (MOSC) 5 commentsAnswered

The official documentation of DBMS_ASSERT.SQL_OBJECT_NAME says that "This function verifies that the input parameter string is a qualified SQL identifier of an existing SQL object.".  I repeat "SQL object".

When applied to an existing index name it fails with "ORA-44002: invalid object name". So an index is not "SQL object"?

Try this:

CREATE USER test1 IDENTIFIED BY passw0rd; CREATE TABLE TEST1.t1 (c1 VARCHAR2(10));CREATE INDEX TEST1.t2 ON TEST1.t1 (c1);SELECT OWNER, object_name, object_type FROM ALL_objectsWHERE object_name LIKE 'T_'AND OWNER = 'TEST1';SELECT DBMS_ASSERT.SQL_object_NAME('TEST1.T1') FROM dual;SELECT DBMS_ASSERT.SQL_object_NAME('TEST1.T2') FROM dual;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center