The standard for writing scripts in our company is to put some boilerplate around the actual object declaration. For example, the following comes after the declaration of a package spec:
show errors;
PROMPT =========================================================================
PROMPT Creating SYNONYM Dbk_Img_Object_Xref
PROMPT =========================================================================
DROP PUBLIC SYNONYM Dbk_Img_Object_Xref;
CREATE PUBLIC SYNONYM Dbk_Img_Object_Xref FOR da.Dbk_Img_Object_Xref;
GRANT EXECUTE ON Dbk_Img_Object_Xref TO cmic_role_all;
PROMPT =========================================================================
PROMPT Completed Dbk_Img_Object_Xref.ps
PROMPT =========================================================================
And the following comes after the package body:
show errors;
PROMPT =========================================================================
PROMPT Created PACKAGE BODY Dbk_Img_Object_Xref
PROMPT =========================================================================
Through your forum I learned to check the