Various errors occurs when clicking on the Script tab of a view in the database explorer, generates errors:
A couple of samples of error being generated:
SAMPLE 1
ORA-06502: PL/SQL: numeric or value error
LPX-00210: expected '<' instead of 'n'
ORA-06512: at "SYS.UTL_XML", line 0
ORA-06512: at "SYS.DBMS_METADATA_INT", line 3688
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4544
ORA-06512: at "SYS.DBMS_METADATA", line 4
SAMPLE 2
ORA-31603: object "CHARTER_MAIL_QUANTITIES" of type VIEW not found in schema "CCOM"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2805
ORA-06512: at "SYS.DBMS_METADATA", line 4333
ORA-06512: at line 1
The user is able to see the script using another SQL Editor with similar functionality.
NOTE: Error only occurs on this one view.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center