Hi everyone,
I create a dblink or a view on my user for dblink. When I run select or update on DB, it is very fine. I try it on object browser on Oracle Apex, it shows me the data. But according to select, I try query on select list of page item, it shows nothing ( bonus: I run in on IR, it still shows nothing).
Compared to update, while I run on DB it updates my value for db link table, on Apex it shows me the message:"connection from ORACLE to a non-Oracle system returned this message: [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.32-0ubuntu0.18.04.1-log]Prepared statement needs to be re-prepared"
Can anyone help me to solve that problem? I look for around on GG, a few idea related to config listener, but I don't think so because my select to db link on DB is normal. Thank you for your time and in advance.