PL/SQL (MOSC)

MOSC Banner

end-of-file on communication channel with DB_LINK

edited Jan 8, 2014 8:00PM in PL/SQL (MOSC) 6 commentsAnswered
Hi all,I have two databases, database a updates a table in database b, along with other database a only lines of code in a pl/sql procedure. When database b is down, I want the rest of my pl/sql  procedure processing to continue, just don't (obviously) update the table in database b. Is there an exception like INVALID_CURSOR or LOGIN_DENIED that represents this condition. The pl/sql procedure has a cursor defined which joins the table1@database_a to table2@database_b. The cursor for loop, again obviously, is not stepped into.
The error is ORA-03113:

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