Oracle WebCenter Sites (MOSC)

MOSC Banner

Using <ics:sql> with a database link

edited Nov 13, 2013 8:46PM in Oracle WebCenter Sites (MOSC) 6 commentsAnswered
Considering the following code:
    <ics:sql
            sql="
                    select * from RemoteTable@REMOTE_DATABASE_LINK
                "
            listname="resultList"
            table="RemoteTable@REMOTE_DATABASE_LINK"    
     />

"REMOTE_DATABASE_LINK"  is for a remote DB server.

The query fails to run with an error "Failed to execute query resultList".
Same happens on changing the table attribute to table="RemoteTable"

What is the table attribute used for ? How does it work ? how can this be achieved ?

Keeping in mind, on changing the  table attribute to any existing table name, the query runs.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center