Database
Discussion List
-
PLSQL arrays and Integration CloudHi All I have an xml array posting to a plsql table and record and that works fine. But I want to set up a GET to return that plsql table into an XML array. The error I … -
APEX_WEB_SERVICE.MAKE_REST_REQUEST Calling OICHello Everyone! I have a situation, I have been using the APEX_WEB_SERVICE.MAKE_REST_REQUEST with the POST method(REST Call) to run the token based OIC Pooler integratio…
-
Database mapper showing parameters as arg1, arg2, arg3,arg4 instead of showing its names.Summary: Content (required): Hi team, We are trying to create a REST API by integrating an Oracle Database with OIC. So as we select the table name and after validating …
-
Give a row in a table some colorSummary How can you give a row in a table some color if it matches a field value?Content Hi guys, At the moment we want to give a row in a table some color when it match…Moenish Baladien 45 views 4 comments 0 points Most recent by User_2025-02-04-21-56-11-668 Visual Builder
-
Attachment download from table in vbcsSummary: Content (required): Hi Everyone, I have an requirement for upload and download the documents. I did upload document process. When am going to download, I didn't…
-
Is it possible to upload attachment in PCS?Summary: Content (required): Hi All, I have an requirement in my project that is. is it possible to upload attachment in PCS ?. i did application with upload attachment …
-
One way Procedure calls in Oracle DB AdapterSummary: Invoke Long running DB procedures is Oracle Database Content (required): We are Invoking Oracle Database procedure from OIC which on has only input parameters. …
-
SDP with input search suggestion with limited results.Summary: The SDP with input search suggestions only fetch only 12 results. Content (required): Hi all, The SDP with input search suggestions values is limited by only 12…
-
The Basics for an Oracle Forms DeveloperHi, apologies, but I am a complete Visual Builder novice, in fact calling me a novice would be a promotion! So, I've built many applications using Oracle Forms in the pa…
-
How to fetch BLOB data(more than 10 MB) from data base to oracle cloud integration?Summary: In atp data base one column has blob data more than 10 MB. we need to handle this data in OIC Content (required): In OIC, we are invoking one procedure where re…User_2025-03-10-21-43-39-199 281 views 1 comment 0 points Most recent by Ganesh Jadhav-178018 Integration
-
Getting MySQL Error on OIC Caused by java.sql.SQLNonTransientConnectionExceptionSummary: Error Message:- DBReadInteractionSpec Execute Failed Exception Query name: [FetchRecordSelect], Descriptor name: [FetchRecord.Test]. Caused by…
-
Can we dump JSON file in ATP table using OICContent I am getting data from JDEdward ERP using rest API in JSON format but JSON is a very weird format and unable to call data in VBCS so I want to dump the JSON file… -
Issue on JSON rest service data insertion in ATP table through OICContent Hi Experts, I am facing an issue while inserting data in the ATP table through OIC. In JSON one child "PENN_SREQ_P41202Components_Repeating" element "item number…
-
When tried to connect to a Onprem Database with Connectivity Agent and a Wallet it throws an errorContent Hi guys, My connection tests successfully when tried on Sql Plus On-Premise and Java On-Premise. But it throws error on Oracle Integration Cloud Service. I am us…User_2025-02-11-13-31-40-371 15 views 2 comments 0 points Most recent by User_2025-02-11-13-31-40-371 Integration -
Read to CSV file using file pickerSummary Read to CSV file using file pickerContent Hi everyone, I have to use the file selector to read a csv file and then insert it into a database. The component is d…
-
Error While Configuring Oracle DBaaS ConnectionSummary Error While Configuring Oracle DBaaS ConnectionContent Hello, Iam getting the below issue, while configuring the Oracle DBaaS connection. Unable to test connecti…Sridhar Yerram-87959 20 views 2 comments 0 points Most recent by User_2025-02-11-13-31-40-371 Integration
-
OIC integration with Oracle NoSQL DBContent Hello, I would like to know if it is possible to integrate OIC with an Oracle NoSQL Database? Thanks in advance. -
Insert into multiple ATP tables from OICSummary Insert into multiple ATP tables from OICContent HI All As part of the integration we are fetching xml data from HCM which need to parsed and enriched to create t… -
VBCS: Tab out from table edit is not triggering "ojBeforeRowEditEnd" action chain but with mouseSummary VBCS: Tab out from table edit is not triggering "ojBeforeRowEditEnd" action chain but with mouseContent Hi All, We are facing a very strange issue with ADP "ojBe…
-
How to read Data from .pdf filesContent Hi Team, we have a requirement to read data from .pdf files .Is it possible in OIC and if not the what are the other way to read the data from .pdf file. Thanks,…
-
How to access rest api in jsSummary How to access rest api in jsContent Hello All, I would like to know how to access rest api in js. Basically i got an action button where I call a java scrip func…
-
Java script function return undefinedContent Hello All, My use case consists 1 function to call another function in js. But it keep returning undefined. I would like to know if i need to do a conversation o…
-
Calling Rest API Via Java script-- Not WorkingSummary Calling Rest API Via Java script-- Not WorkingContent Hello All, I am trying to execute a rest api via java script. Its not working . Please see below part of th…
-
Calling Rest Web servies using a loopSummary Calling Rest Web servies using a loopContent Hello Expert, My use case is to call a rest webservices (get method via ords) in a loop. The number of iteration may…
-
How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB TableContent How to Receive Multi-Part Form Data Json File as Attachment and Insert Data to DB Table? Please advise if anyone has any pointers/blogposts/solution in transform…Shivakumar Ayyanagowdar-Oracle 16 views 4 comments 0 points Most recent by Shivakumar Ayyanagowdar-Oracle Integration -
Storing offset and corresponding data set/records in a 2 dimensional array in VBCSSummary Storing offset and corresponding data set/records in a 2 dimensional array in VBCSContent Hi All, Needed your thoughts on the below use-case. We have one search …
-
ORDS OAuth Serivce connection in VBCSSummary ORDS OAuth Serivce connection in VBCSContent Hi, 1. Before enabling OAuth, I could able to access REST end points in VBCS.... 2. I enabled OAuth for ORDS REST en…User_2025-02-04-08-39-48-494 44 views 13 comments 0 points Most recent by User_2025-02-04-08-39-48-494 Visual Builder
-
Read SQLLoader format fixed length file in OICSummary Read file for staging in OICContent Hi, I am trying to read a fixed length file, which is my source. This file is in sql loader format. In on prem, the control f…
-
Execute select statement on an Oracle Database using variables for limit and offsetContent Hello, I need to execute a select statement on an Oracle Database using variables for limit and offset, but trying to execute the select like in the attached ima…
-
Unable to Connect Azure DatabaseSummary Unable to Connect Azure Database using Microsoft SQL Server AdapterContent Hi I have been trying to connect the Azure Database by following the steps provided th…