view counter


Oracle Application Express (APEX) resources, news, and support articles.

Interesting APEX with dblink issue

We recently ran in to a problem when connecting across a database link to a Postgres database.  The query looked like this

select "column1", "column2"
  from "my_schema"."my_long_named_view"@my_db_link

It works fine from sql*plus and sql Developer, but when running the same query in Application Express (in an app or in the SQL Workshop) we got this error:

Kristian Jones

Jack of Everything, Master of Nothing

Patrick Wolf

Inside Oracle APEX - a blog that helps to get more out of Oracle Application Express (APEX) for your daily development work!

Dimitri Gielis

Dimitri Gielis Blog (Oracle Application Express - APEX)

David Peake

David Peake on Oracle APEX
view counter