When executing a query, the following error is given for the query under Status column.
It is a vaild query. No optimization was previous done. But even if optimizing first (and able to optimize without any problems), then trying to execute, the same error is given. Explain plan runs without any problems.
ORA-06550: line 5, column 20: PLS-00201: identifier 'SYS.DBMS_SQL' must be declared ORA-06550: line 5, column 20: PL/SQL: Item ignored ORA-06550: line 6, column 20: PLS-00201: identifier 'SYS.DBMS_SQL' must be declared ORA-06550: line 6, column 20: PL/SQL: Item ignored ORA-06550: line 8, column 21: PLS-00201: identifier 'SYS.DBMS_SQL' must be declared ORA-06550: line 8, column 4: PL/SQL: Statement ignored ORA-06550: line 9, column 5: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 9, column 5: PL/SQL: Statement ignored ORA-06550: line 13, column 4: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 13, column 4: PL/SQL: Statement ignored ORA-06550: line 17, column 4: PLS-00320: the declaration of the type of this expression is incomplete or malformed ORA-06550: line 17, column 4: PL/SQL: Statement ignored ORA-06550: line 21, column 4: PLS-00320: the declaration of the type of this expression is incomplete or malformed
This is still an issue if trying test with SELECT * FROM DUAL;
Reinstall does not help.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center