closing a database link in Dynamic pl/sql loop
Hi ,
I need the help of Oracle sql professionals !
I have the following PL/SQL procedure which loops in a list of database link names ( db link names are stored in a table ) and reads v$database .
In case of errors , it inserts a record in a log table and sends an email .
The problem that the DB link is not closed after the work .
Probably the problem resides in the location of CLOSE statement . tried different options , but did not wok .( still the connection is open )
Please help and thank you in advance :
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE check_up_down_prod
I need the help of Oracle sql professionals !
I have the following PL/SQL procedure which loops in a list of database link names ( db link names are stored in a table ) and reads v$database .
In case of errors , it inserts a record in a log table and sends an email .
The problem that the DB link is not closed after the work .
Probably the problem resides in the location of CLOSE statement . tried different options , but did not wok .( still the connection is open )
Please help and thank you in advance :
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE OR REPLACE PROCEDURE check_up_down_prod
0