PL/SQL (MOSC)

MOSC Banner

How to Execute Remote procedures that use DBLinks?

edited Jan 29, 2010 3:08AM in PL/SQL (MOSC) 8 commentsAnswered
I have created a procedure that I execute remotely by issuing the following:

CALL GLOBAL.REFRESH_STAGING@KRONOSLINK();

The procedure errors as

Error at line 2
ORA-20001: ERROR OCCURED
ORA-06512: at "GLOBAL.REFRESH_STAGING", line 47
ORA-06512: at line 1

The procedure runs without error from the host database.  The problem is when the procedure makes a call to the dblink.
I unsuccessfully attempted to capture the error message.

Question:  Is it possible to execute remote procedures that use dblinks?  If so, How is that accomplished.
Question:  What is the proper way to handle exceptions in this case?

Bonus:   What can be done to improve this procedure? (Suggestions, like adding return on the procedure).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center