APEX

[Required Layout|http://imgur.com/aX3hR]

Hi All,

I am trying to create a dynamic layout using Apex as shown in the above link.

The required functionality is to allow the user to select the database (note only 2 shown but there are several), this would then update the Db field which would then update the table field dynamically.

Each database has the same structure but is located on a different machine.

I have created a database link to allow access to them and then created a view

create or replace view sec_app_build11m
as select * from sec_applications@build11m;

The tabular form which will allow the update of the data on the remote database via the database link is populated thus:

select
"APP_NAME",
"APP_NAME" APP_NAME_DISPLAY,
"APP_DESC",
"APP_VERSION",
"APP_VSN_DATE",
"APP_OMEGA",
"APP_KEY",
"APP_KEY2"
from "#OWNER#"."SEC_APP_BUILD11M"

My problem is that as soon as I try and change the from clause to be dynamic and reference the DB field:

from &P9_DB.

it produces an Oracle error:

1 error has occurred
Query cannot be parsed within the Builder. If you believe your query is syntactically correct, check the ''generic columns'' checkbox below the region source to proceed without parsing. ORA-00903: invalid table name

I am new to Apex and think that this may not be possible to achive in Apex so before I spend a lot of time trying to figure it out I thought I would ask for advice.

Many Thanks

Dave