How to execute a StoredProcedure on a remote database

From: Xavier Darcos <xdarcos_at_astek.fr>
Date: Thu, 16 Dec 1999 14:47:05 +0100
Message-ID: <3858ED59.AA1D990F@astek.fr>

Hi,

To refresh the snapshots on a remote database named "Grenoble", I created this stored Procedure :

Procedure SNAP_REFRESH
is
begin

dbms_snapshot.refresh('parameters','c');
dbms_snapshot.refresh('streets','c');
dbms_snapshot.refresh('towns','c');

end;

But when executing it from another database : execute SNAP_REFRESH_at_Grenoble, I've got this message :

SQLWKS> execute snap_refresh_at_grenoble;

ORA-01001: Cursor not valid
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 140
ORA-06512: at "GRENOBLE.SNAP_REFRESH", line 3
ORA-06512: at line 2

even if I gave Grant to this procedure : GRANT EXECUTE ON "GRENOBLE"."SNAP_REFRESH" TO PUBLIC; What's wrong ?

Thank you

Xavier Received on Thu Dec 16 1999 - 07:47:05 CST