Database
Discussion List
-
How to pass arguments to DBaas adapter in OIC?Summary How to pass arguments to DBaas adapter in OIC?Content Hi All, We have requirement to pass arguments to the sql query. Below is the sample query. SELECT FNAME, LN… -
Connecting to OCI(Oracle Cloud Infrastructure) DB from OICSummary Not able to establish connection to OCI DBContent Hi Experts, We have moved from DB classic to DB OCI for database management. The OIC connectivity agent is inst…
-
Problem with Stored Procedure InvokeSummary Unable to invoke Stored Procedure when has Associative Array as inputContent Hi, I am trying to invoke a stored procedure from OIC through DB adapter, the invoke…
-
Runtime Fault/Exception Handling in OIC (Oracle SOA Fault Policy Functionality?)Summary Is Oracle SOA Fault Policy Functionality also present in OIC? Especially handling runtime fault on server sideContent Hello OIC Gurus, Oracle SOA has this Fault … -
Can we Poll a table by considering more than one column flag using DB AdapterSummary I want to poll a table by checking two column flag values. Is that possible in ICS?Version 18.3.3.0.0
-
Issue Activating ICS Integration - DB Adpater IssueSummary Facing Issue while Activating ICS Integration with DB adapter configured.Content We are now facing issue in activating and ICS integration with DB adapter. I'll …
-
Retrieve SOA-MDS passwordSummary How to retrieve the SOA-MDS password and configure the db based MDS connection from jdeveloperContent We created a SOA instance and corresponding database instan…
-
Does OIC have data warehouse features?Summary Does OIC have data warehouse features?Content We need to be able to archive files from source locations. Does OIC have any archival or data warehouse features?
-
Downtime Handling in OICSummary We encountered intermittent connection (2-3 minutes of random downtime) in OICContent Hi, We encountered intermittent connection (2-3 minutes of random downtime …
-
Custom SQL queries against Cloud ERP via OAICSSummary Custom SQL queries against Cloud ERP via OAICSContent Hi All, I am building an integration in OAICS, based on (I expect a common scenario) where we are creating … -
Select statement with DB2 connector doesn't return anything to mapSummary Using the DB2 connector to connect to DB2 over port 446, select statement validates and generates and xsd but there is not outbound mapping.Content I administer … -
ICS: Agent not showing in DB Connection Agent Confguration after installing the On-Premise AgentSummary The agent is not showing in the 'Configure Agents' interface when doing DB Connection setup in ICSContent Hi, We are using ICS Standard Edition, Version: 18.2.3.…
-
Connection Timeout in REST adapterContent Hi, I have a use case where I have to insert the data from BI report into the database. I have exposed the data insertion as REST service using ORDS. In some cas…
-
ICS Database connection after patching on DB prevent "existing state of packages has been discarded"Summary ICS Database connection after patching on DB prevent "existing state of packages has been discarded"Content Hi together How can I prevent after patching the data…
-
How to migrate integrations from One OIC instance to another including database packagesSummary How to migrate integrations from One OIC instance to another including database packagesContent We have built around few custom integrations , we would like to m…
-
OIC Mapping with DBSummary OIC Mapping with DBContent Hello Experts, I am trying to map the source/target parmeters which are coming from a Stored procedure and one of the out params is cu…
-
ICS asynchronous callSummary ICS asynchronous callContent Hi, It is possible to invoke a database procedure with ICS asynchronous, without waiting of a result? Regards Fabian.
-
ICS Write request XML into the databaseSummary ICS Write request XML into the databaseContent Hi, It is possible to write the request XML from the SOAP trigger as CLOB into a 12c Oracle Database table? Regard…
-
Response variable not found on the databaseSummary Response variable not found on the databaseContent Hi Team, I'm facing an issue while developing an integration. where as integration monitoring, the value is pr…Janardhan Kothapalli 16 views 18 comments 0 points Most recent by Hemanth Lakkaraju-Oracle Integration
-
MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agentSummary MySQL adapter cannot connect (needs JDBC jar?) Using On-Prem agentContent I have an OIC instance with an On-Prem adapter installed within my firewall. The On-Pre…
-
Error While inserting Data into DBaas through ICS "Inserted value too large for column:"Summary Error While inserting Data into DBaas through ICS "Inserted value too large for column:"Content Hi All, I am encountering the following error while trying to ins…