Using <ics:sql> with a database link
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.
<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.
0