APEX

Hi

I have an application here developed using Apex 3.1 in Oracle XE. This application has a page that dynamically executes SQL statements against the local database or a remote databases (via dblinks). The user selects a dblink (or leaves it empty for the local database) and clicks a button that runs a process that calls a procedure in the database. This procedure executes the mentioned dynamic SQL.

If I run my app against my local database, all works fine.

If I run it against a remote database (EE 10g), strange things start to happen when I click the button. Sometimes, after clicking it, an empty page is displayed (without any error message). If I click back in the browser and try again, it works fine.

Sometimes instead of a page being displayed, I am asked what I want to do with a file called "wwv_flow.accept". If I save it, it contains:

IBMPC/WIN_NT-8.1.0

If I click the button again, it works fine. It looks like something gets messed up right after executing a dynamic SQL over a dblink.

I didn't do much investigation yet, and I would like to know if anyone have seen this before...

Thanks,
Luis