1 person found this helpful
In order for the wizards in APEX Developer to 'see' the data and code schemas, you have to "link" them to the workspace.
This is done within the APEX Admin portal:
"manage workspace" -> "Manage workspace to schema assignment"
Add your other schema(s) there.
As far as I can tell, APEX does not do any grants. it just adds a row to the table that the wizards use for their LOVs.
Interesting enough, if you write the SQL or PL/SQL yourself, you don't need to 'link' the workspaces.
(but you still need to have the correct 'grants')
The wizard won't pick up synonyms (at least, that is what I noticed too). The usual way around this is to create a view in XX2:
create view my_table
as select * from XX1.my_table
There was a good blog by Scott Spendolini about this approach (Secure Apex Development), but a link I had for this is now invalid.
Oh, here is a copy:
Thanks Inol, that's a good pdf - pages 37-40 are pretty much spot on to what I need although I'm keen to avoid having to write the DML myself as the latest tabular form wizard seems to do a good job of it. I'll go down the path of views at this point and if there's a complex requirement, I guess i'll write the DML.