-- Failed to execute: SQL Statement ==> ORA-31603: object "WORKSHIFT_VIEW" of type TABLE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2588
ORA-06512: at "SYS.DBMS_METADATA", line 2827
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5336
ORA-06512: at "SYS.DBMS_METADATA", line 6702
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TABLE', 'WORKSHIFT_VIEW' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> ORA-31603: object "TEST1" of type TABLE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2588
ORA-06512: at "SYS.DBMS_METADATA", line 2827
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5336
ORA-06512: at "SYS.DBMS_METADATA", line 6702
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TABLE', 'TEST1' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> ORA-31603: object "TAX_INVOICE_VOUCHER_VIEW" of type TABLE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 2588
ORA-06512: at "SYS.DBMS_METADATA", line 2827
ORA-06512: at "SYS.DBMS_METADATA", line 3608
ORA-06512: at "SYS.DBMS_METADATA", line 5008
ORA-06512: at "SYS.DBMS_METADATA", line 5336
ORA-06512: at "SYS.DBMS_METADATA", line 6702
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TABLE', 'TAX_INVOICE_VOUCHER_VIEW' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> SQLException : ORA-31603: object "ST00001+VUMHT/4ZVGY80AEKWVNA=" of type TYPE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TYPE', 'ST00001+VUMHT/4ZVGY80AEKWVNA=' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> SQLException : ORA-31603: object "ST00001+VUMHT64ZVGY80AEKWVNA=" of type TYPE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TYPE', 'ST00001+VUMHT64ZVGY80AEKWVNA=' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> SQLException : ORA-31603: object "ST00001+VUMHUE4ZVGY80AEKWVNA=" of type TYPE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TYPE', 'ST00001+VUMHUE4ZVGY80AEKWVNA=' , 'APPVIS') FROM DUAL

 -- Failed to execute: SQL Statement ==> SQLException : ORA-31603: object "ST00001+VUMHUJ4ZVGY80AEKWVNA=" of type TYPE not found in schema "APPVIS"
ORA-06512: at "SYS.DBMS_METADATA", line 6731
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 6718
ORA-06512: at "SYS.DBMS_METADATA", line 9734
ORA-06512: at line 1
 --SELECT DBMS_METADATA.GET_DDL('TYPE', 'ST00001+VUMHUJ4ZVGY80AEKWVNA=' , 'APPVIS') FROM DUAL

-- No of Rows = 7