OIC Architecture Question:

Summary: We recently implemented OIC. Part of that implementation included PL/SQL packages which are called by the OIC integration platform. We believe is typical architecture, and just fine. The PL/SQL and some tables, which are used to drive the OIC integrations, are stored in a custom DBaaS schema. We have other data sets, which are used by the OIC PL/SQL packages, housed within separate schemas in the same DBaaS database instance. This allowed us to reference the "remote" dataset directly from within the PL/SQL using simple schema.table notation. For example:

select <columns> from OIC-schema.table A, non-OIC-schema.table B