view counter

APEX Feed

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

Joel Kallman

(YABAOAE) Yet Another Blog About Oracle Application Express APEX

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