Oracle Database Discussions

Hello,

Scenario - 2 databases :
Database DB_1 ; Table T1
Database DB_2 ; Table T2, T3


I am writing a procedure @ 'Database DB_2' where in write some query on T2 and T3 and the collected records will be inserted into Database 'Database DB_1'
through link

Link
---------------------------
create database link "to_db_2_from_db_1"
CONNECT TO "markK" IDENTIFIED BY mark USING
' ( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.222)(PORT = 1521) ) ) ( CONNECT_DATA = (SID = db_1) )) '
;
---------------------------

Procedure :
---------------------------
1. create or replace
2. PROCEDURE PROC_POSITION_FLOW_TO_db_1(
POSDATE IN DATE )
IS
DATEFORMAT VARCHAR2(10) := '';
ALTERED_POSDATE DATE ;

BEGIN

3. EXECUTE IMMEDIATE 'ALTER SESSION SET GLOBAL_NAMES = TRUE';
EXECUTE IMMEDIATE 'SELECT PARAMVALUE FROM PARAMETER WHERE UPPER(TRIM(PARAMNAME)) IN (''' || 'ORACLESHORTDATEFORMAT' || ''')' INTO DATEFORMAT ;

4. ALTERED_POSDATE := TO_DATE(POSITIONDATE, DATEFORMAT);
DBMS_OUTPUT.PUT_LINE( DATEFORMAT || ' ' || ALTERED_POSDATE );

5. INSERT INTO T1@TO_RISK_DOM_IN_XE
Begin Query code
Select * from t2, t3
End Query code

EXECUTE IMMEDIATE 'COMMIT';



END PROC_POSITION_FLOW_TO_RISKMARK;
---------------------------

The procedure complies without error.
But when I run it it throws
ORA-02085: database link to_db_2_from_db_1.REGRESS.RDBMS.DEV.US.ORACLE.COM connects to db_1

Please let me know how to resolve this error..
what is the solution.