Hi,
I have PL/SQL stored procedure in wich a remote SELECT is performed using a dbLink to database named remoteDB.
The DBA set a timeout for inactive connections on remoteDB database.
The PL/SQL is as following
[tt]
CREATE PROCEDUERE some_proc
IS
--Some declarations here
BEGIN
insert into table1
select * from remote_table1@remoteDB ;
commit ;
insert into table2
select * from local_table2 ;
commit ;
Execption
--- exception handling sending the sqlerrm by mail
END ;
[/tt]
What is happening is that the first SQL is executed correctly, I find the rows inserted in table1.
But it not inserting in table2. And the error message that arrives is :
[tt]
ORA-02068: following severe error from remoteDB
ORA-03113: end-of-file on communication channel
[/tt]
What I'm thinking about is a statment between the two SQLs that closes the connection to remoteDB after finishing the first INSERT statment.
How to do that ?
Regards,
Zephan
I have PL/SQL stored procedure in wich a remote SELECT is performed using a dbLink to database named remoteDB.
The DBA set a timeout for inactive connections on remoteDB database.
The PL/SQL is as following
[tt]
CREATE PROCEDUERE some_proc
IS
--Some declarations here
BEGIN
insert into table1
select * from remote_table1@remoteDB ;
commit ;
insert into table2
select * from local_table2 ;
commit ;
Execption
--- exception handling sending the sqlerrm by mail
END ;
[/tt]
What is happening is that the first SQL is executed correctly, I find the rows inserted in table1.
But it not inserting in table2. And the error message that arrives is :
[tt]
ORA-02068: following severe error from remoteDB
ORA-03113: end-of-file on communication channel
[/tt]
What I'm thinking about is a statment between the two SQLs that closes the connection to remoteDB after finishing the first INSERT statment.
How to do that ?
Regards,
Zephan