Select * from user_db_links

DB_LINK	USERNAME	PASSWORD	HOST	CREATED

MyDBLINK.blah.COM			MyDBLINK	7/5/2008 4:07:02 PM

Select * from TABLE3@MyDBLINK;

-- Ok it returns records --

Something1 Something2
123        abc
456        def

CREATE OR REPLACE FUNCTION MyFunc1 (v_addr_id NUMBER)
RETURN NUMBER
IS
.
.
d_b_id  TABLE1.b_id@MyDBLINK%TYPE;
d_ga_id TABLE2.ga_id@MyDBLINK%TYPE;

Begin
.
.
IF ... THEN

          INSERT INTO TABLE3@MyDBLINK
           (something1,
            something2
            )
            VALUES
           (value1,
            value2
            );
            COMMIT;
ELSIF ... THEN
          UPDATE TABLE3@MyDBLINK
           SET ...
           .
           .
          WHERE ...
          COMMIT;

END IF;
END;

Begin
MyProc1;
End;

-- Logs --

* FILE: File1.TXT EVENT: I A_ID: 100
* FILE: File1.TXT EVENT: I A_ID: 101
* FILE: File2.TXT EVENT: U E_A_ID: 201
* FILE: File2.TXT EVENT: I E_A_ID: 205
* FILE: File2.TXT EVENT: U E_A_ID: 205

* ROLLBACK - Message: ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from MyDBLINK -1017

ORA-01017: invalid username/password; logon denied 

Cause: An invalid username or password was entered in an attempt to log on to Oracle. The username and password must be the same as was specified in a GRANT CONNECT statement. If the username and password are entered together, the format is: username/password. 

Action: Enter a valid username and password combination in the correct format.  

---

ORA-02063: preceding stringstring from stringstring 

Cause: an Oracle error was received from a remote database link. 

Action: refer to the preceding error message(s)  

select * from user_sys_privs

USERNAME	PRIVILEGE	ADMIN_OPTION

MySchema	GRANT ANY PRIVILEGE	NO
MySchema	CREATE SESSION	        NO
MySchema	UNLIMITED TABLESPACE	NO
MySchema	CREATE DATABASE LINK	NO
MySchema	UPDATE ANY TABLE	NO
MySchema	CREATE EXTERNAL JOB	NO
MySchema	CREATE TABLE	        NO
MySchema	INSERT ANY TABLE	NO
MySchema	CREATE ANY TRIGGER	NO
MySchema	CREATE ANY SYNONYM	NO
MySchema	CREATE PUBLIC SYNONYM	NO
MySchema	CREATE USER	        NO
MySchema	SELECT ANY TABLE	NO
MySchema	CREATE SYNONYM	        NO
MySchema	CREATE VIEW	        NO
MySchema	CREATE JOB	        NO
MySchema	DROP ANY TABLE	        NO
MySchema	DROP ANY SYNONYM	NO
MySchema	GRANT ANY ROLE	        NO
MySchema	ALTER USER	        NO
MySchema	DROP ANY ROLE	        NO
MySchema	EXECUTE ANY PROCEDURE	NO
MySchema	DROP PUBLIC DATABASE LINK	NO
MySchema	CREATE PUBLIC DATABASE LINK	NO
MySchema	DROP PUBLIC SYNONYM	NO
MySchema	CREATE ROLE	        NO

---

Select * from user_db_links

DB_LINK	USERNAME	PASSWORD	HOST	CREATED

MyDBLINK.blah.COM			MyDBLINK	7/5/2008 4:07:02 PM