Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Dev & ORA12C_VERIFY_FUNCTION in PDB & CDB

dougkAug 16 2021

Running SQL Developer 21.2.1.
I am fairly new to 19c (19.10) multitenant and noticed something unusual with how SQL Developer displays the password verify function when the version in the PDB differs from the one in the CDB.

OWNER      OBJECT_NAME               CON_ID
---------- ------------------------- ----------
SYS        ORA12C_VERIFY_FUNCTION       1
SYS        ORA12C_VERIFY_FUNCTION       4

When logged in to the CDB, in the object tree view there is one entry for ORA12C_VERIFY_FUNCTION and the corresponding code matches the version in the CDB.
When logged in to the PDB, there are two (duplicate) entries in the tree view, both with the same name and both displaying the version of the function deployed to the PDB.
image.pngIs this a SQL Developer issue, or is it inadvisable to have a different verify function in the PDB?
Regards,
Doug

Comments
Post Details
Added on Aug 16 2021
10 comments
1,536 views