CODEWITHSUNDEEP
javaoracle-databaseexternaldblinkoracle-apex-5
bprasanna
bprasanna

Reputation: 2453

Is it possible to connect to DB in Oracle APEX application externally?

I am trying to query the table stored in Oracle APEX application externally (using Java). But, i am quite not sure on achieving it. Because, inside APEX i was able to access external databases using dblink. But, the other way around is puzzling me. It starts from what should be the connect string, will there be host & port details etc.,.

Search on oracle docs and other dba forums didn't cover this scenario. It would be a great help if someone can give a pointer on this.

Upvotes: 3

Views: 7732

Answers (1)

rarspace01
rarspace01

Reputation: 419

According to the comments you're trying to access the apex.oracle.com Database externally - which isn't possible. The only valid way to access your database in the online demo workspaces from oracle is via the SQL Workshop or your APEX applications. If there's a need for accessing the data from outside i highly suggest using the RESTfull services from APEX. A direct connection via JDBC isn't possible.

Upvotes: 2

Related Questions