APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query cannot be parsed(ORA-00903: invalid table name)

846231Jun 13 2012 — edited Jun 13 2012

Hi all,

I am creating a report on a remote table using a database link which connects to the system schema so it can access any schema tables in the link.

But the schema name and db_link name is variable which is passed on by the "parent" table which has column "schema" and "db_link".

So the link report base sql query is

SELECT * FROM :P2_SCHEMA.EMP@:P2_DB_LINK

Is this not allowed? Can I have a workaround for this?

Thanks a lot,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2012

Added on Jun 13 2012

#apex-discussions

9 comments

659 views