Return
-
Title
Error when compiling code that queries SYS schema views: "PLS-0020: identifier 'SYS.<view>' -
Description
Error when compiling code that includes a select statement querying a view in SYS schema: "PLS-00201 identifier 'SYS.<view>' must be declared". The SYS view can be queried outside of code as a standalone query. The SELECT_CATALOG_ROLE role is granted to user.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.