Oracle Database Discussions

Hello,

I have a requirement to interface from my Oracle APEX application to a third party Lotus Notes application.

This would be a two way interface

1) Lotus notes app to call an Oracle packaged procedure to insert into some Oracle tables
2) Oracle APEX App via a Table Trigger to insert into a Lotus Notes table

After the inserts it should be possible to view the data in the Oracle APEX app and in the Lotus Notes app

I am a complete novice to Java but I understand JDBC could be a good method to solve this requirement

For the two way interface the Oracle code would be

1) Lotus notes app to call an Oracle packaged procedure to insert into some Oracle tables

te_pkg.insert_project
(I_work_request_no IN VARCHAR2
,I_description IN VARCHAR2
,I_originator_email IN VARCHAR2
,I_auth_user_email IN VARCHAR2
,I_it_manager_email IN VARCHAR2
,I_raised_date IN DATE
,I_latest_est_days IN NUMBER
)

2) Oracle APEX App via a Table Trigger to insert into a Lotus Notes table

CREATE OR REPLACE TRIGGER TRIG_proj_AFTER
AFTER
UPDATE ON Project FOR EACH ROW
BEGIN
IF :new.status = 3 THEN -- Project Completed
/*
**
** INSERT INTO Lotus notes temp table with :new.work_request_no, :new.status
**
*/
END IF;
END;
/

Any suggestions and code snippets, particularly for pushing the Project Status INSERT to Lotus Notes would be appreciated.
I stress again I am a complete novice to JAVA so simple step by step instructions would help.

Kind Regards

Ade