Hi
I tried to generate log , but I did not to see error, What is wrong ?
MY SCRIPT
SET TIMING ON;
SET TIME ON;
SET LINESIZE 1000
SET SERVEROUTPUT ON
SET ECHO OFF
SPOOL C:\LOG_AJUSTA_CRM.LOG
@@CRIA_TABS_AUXS.SQL;
@@PR_EQPTO_CRMXSN_AGRUPADO.sql;
@@PKG_AJUSTA_CRM_H.SQL;
@@PKG_AJUSTA_CRM_B.SQL;
show errors;
commit;
SPOOL OFF
But when The People that executed Script , mail me log as :
DROP TABLE SYSADM.TMP_EQUIP_CRM
ORA-00942: table or view does not exist
DROP TABLE SYSADM.TMP_EQUIP_CRM_FULL
ORA-00942: table or view does not exist
DROP TABLE SYSADM.TMP_PS_LOC_ITEM
ORA-00942: table or view does not exist
DROP TABLE SYSADM.TMP_CALC_FATOR
ORA-00942: table or view does not exist
Table created
Executed in 3,563 seconds
Index created
Executed in 0,594 seconds
Table created
Executed in 0,125 seconds
Table created
Executed in 0,172 seconds
Table created
Executed in 1,969 seconds
Index created
Executed in 0,094 seconds
Procedure created
Executed in 12,157 seconds
Package created
Executed in 1,375 seconds
Warning: Package body created with compilation errors
Executed in 7,078 seconds
Commit complete
Executed in 0,015 seconds
My package compiled with errors , but I did not know Why ?
Some can help me ?