Hi experts,
Here's my setup: Oracle Dabatabse 23ai and APEX 24.2.0.
I've successfully established heterogeneous connectivity between Oracle 23ai and PostgreSQL using ODBC. I've defined a PG_LINK database link, and the link works perfectly.
In my application, I have a report and a form. The report data is populated by a view that relies on data from a table in my remote PostgreSQL database (PG_LINK). From my form, I want to edit the information in my report, but I'm getting an error message.
I've tried three options:
1 - Updating the view i created with the following pl/sql block, but nothing happens;
BEGIN
UPDATE V_ACTIVCOMPTE_ECNPS
SET AG_ID = :P7_AGENCE_AFFECTATION,
ACTCO_DATEMODIF = SYSDATE
WHERE ACTCO_ID = :P7_ID;
COMMIT;
END;
2 - Direct update of the remote table, but I get the error ORA-04052: Errors while consulting the remote object postgres.activ_compte@PG_LINK
3 - Creating a procedure that I will call directly in my APEX process, but again I get the error message ORA-04052: Errors while consulting the remote object postgres.activ_compte@PG_LINK ORA-00604: An error occurred at the recursive SQL level 4. Check for the following errors: ORA-28500: Connection from ORACLE to a non-Oracle system returned
Any possible solutions will be appreciated.
Thank you