> I have this script that keeps bugging me with an Oracle error ORA-00942 that > should not be there. All the tables in the script are owned by 'DBREPORTER' > who is running the script. I have executed the same SQL commands directly > with SQLPlus and they work fine. Even more, the same SQL commands had been > running within a PLSQL procedure for 1 year and they worked fine. So there's > something I am missing.
> /export/home/oracle>DBD::Oracle::db do failed: ORA-00942: table or view does > not exist (DBD ERROR: error possibly near <*> indicator at char 542 in > 'INSERT INTO system_events > SELECT a.database, ... > FROM t_se a, > (SELECT event, total_waits, total_timeouts, > FROM dbreporter.<*>system_events > WHERE database = 'BISP.emea.fedex.com' > AND time = (SELECT MAX(time) FROM > system_events WHERE database = 'BISP.emea.fedex.com')) b > WHERE a.event = b.event(+) > AND a.database > = 'BISP.emea.fedex.com' ') [for Statement "INSERT INTO system_events > SELECT a.database, ... > FROM t_se a, > (SELECT event, total_waits, > FROM system_events > WHERE database = 'BISP.emea.fedex.com' Why does the error string say "FROM dbreporter.<*>system_events" but the appended Statement string (and the script) says "FROM system_events"? Tim.
