You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Define the schema in an Autonomous DB connection at the Mapping Level

edited Jul 21, 2021 9:09PM in Idea Lab – Integration Cloud 2 comments

Description

When referencing Stored Procedures in an Autonomous Database the schema is a mandatory field in the configuration.  The Schema is hard coded into the connection - it can not be varied by mapping.

We are trying to use one ATP Database across several non-prod environments, separating data sets by Schema.  However we also make use of a number of stored procedures in the database(for performing XML file merge operations and the like, as these are more efficient that record by record transformation).  When referencing a stored procedure the schema is hardcoded in the end-point, meaning we have to edit the integration flow to change from one schema to another.  If the schema could be defined in the end-point mapping we would be able to use a variable to define this, potentially holding it in an

5 votes

Submitted · Last Updated

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!