This is my procedure
CREATE OR REPLACE PROCEDURE sp_SyncStart
INSERT INTO care_admin.coventry_adPerSyncLog
SELECT * FROM yyuniv.adPerSyncLog@UNIVERSE;
DELETE FROM yyuniv.adPerSyncLog@UNIVERSE;
but I get lovely errors
PL/SQL: ORA-04052: error occurred when looking up remote object
ORA-00604: error occurred at recursive SQL level 1
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this
expression is incomplete or malformed
ORA-02063: preceding 2 lines from UNIVERSE
I tried running the insert statement directly via SQL Plus and it worked correctly. Not sure why it works interactively but not contained in a procedure.
Any ideas anyone? Thanks in advance for you help.