Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sv: How to execute a StoredProcedure on a remote database

Sv: How to execute a StoredProcedure on a remote database

From: Lars Bo Vanting, COREBIT SYAP/TPI AG <LarsBoV_at_COREBIT.ch>
Date: Thu, 16 Dec 1999 14:53:04 +0100
Message-ID: <83aqrg$j8g$1@news1.sunrise.ch>


You are not allowed to REMOTELY (RPC) execute procedures which performs a COMMIT, I guess this is your problem. One work-around is to instead change the "Refresh Next" information on each refresh group to "now", i.e. sysdate, this can be done remotely...

Kind regards
Lars Bo vanting
COREBIT SYAP/TPI AG, Switzerland

Xavier Darcos <xdarcos_at_astek.fr> skrev i en nyhedsmeddelelse:3858ED59.AA1D990F_at_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:53:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US