Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure that uses DB Link - Doubt on dependency

zzzzzzzMar 8 2018 — edited Mar 8 2018

Hi All,

It is a generic question - I dont have an option to test it.

I have a procedure which has a  IF ... ELSIF ... ELSE .. END IF construct.

In one of the ELSIF  part, a table from db link ( TEST_TABLE@test_dblink )is used ( Just a note: This procedure runs daily once and normally the ELSIF which uses dblink will not get executed. The condition will match very rarely only )

My question is : If the db corresponding to test_dblink is down, will it impact the execution of my procedure ( assuming the ELSIF part whcih uses dblink will not come true in this instance of run ) .

I know that the execution will fail, if that particular ELSIF part comes true. Will the procedure become invalid at that time ?

Will the procedure become invalid only if it gets compiled next time because of some other reason ?

Thanks in advance.
This post has been answered by BrunoVroman on Mar 8 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2018
Added on Mar 8 2018
17 comments
2,596 views