I have this database which includes a couple of schemas. Say I need to access schemaONE from schemaTWO. To do this, I have created a database link named "DB_ONE_LINK".
I am able to access to schemaONE's tables using the following syntax:
SELECT * FROM "Tbl1"@"DB_ONE_LINK";
Now, when creating SPs and functions in schemaONE, I can define variables like this:
The question is, how can I reference to a field type in schemaONE using "DB_ONE_LINK"? something like this:
Is it even possible?