SELECT INITCAP(status) FROM dba_objects WHERE owner = 'SYS' AND object_name = 'UTL_FILE' AND object_type = 'PACKAGE'; 看看是不是valid
SQL> SELECT INITCAP(status) FROM dba_objects WHERE owner = 'SYS' AND object_name = 'UTL_FILE' AND 2 object_type = 'PACKAGE'; SELECT INITCAP(status) FROM dba_objects WHERE owner = 'SYS' AND object_name = 'UTL_FILE' AND * ERROR 在行 1: ORA-00942: 表格或視觀表不存在繼續鬱悶...........
object_type = 'PACKAGE';
看看是不是valid
2 object_type = 'PACKAGE';
SELECT INITCAP(status) FROM dba_objects WHERE owner = 'SYS' AND object_name = 'UTL_FILE' AND
*
ERROR 在行 1:
ORA-00942: 表格或視觀表不存在繼續鬱悶...........