ORDS and REST
Discussion List
-
Hi I am facing issue while passing rec array as input parameter in ORDS exposed package procedureSummary: I am facing an issue and not sure about doing it correctly I created a package and created a record type and CREATE OR REPLACE PACKAGE my_test_package AS TYPE t… -
Is it possible to use Oracle Database API for MongoDB to run rocket.chat?Summary: I am trying to connect RocketChat with Oracle-DB, but get error "MongoServerError: Invalid index specification: text index only support on wildcard" Content (re… -
Transparent Data EncryptionWe are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database. we have used the below query for creating a table with encrpted column, b…Narayanan V-Oracle 21 views 4 comments 0 points Most recent by Venkat Koduvayur-Oracle Autonomous Database
-
Production Live with Free Tier ATPSummary: Hi Team, Has anyone gone LIVE in production with Free Tier ATP. Do you see any challenge with that. Our data volume is less and 20 GB is enough. So just looking… -
How to call a SOAP request in PLSQLSummary:Hello ,I have created a SOAP request which is working fine when I am using SOAP UI .But how to invoke the same SOAP request through PLSQL ?Can someone pls give s…
-
apex_web_service.make_rest_request always gives error insufficient privilegesSummary: I am trying to set up a small API with my home automation and the Oracle cloud. To do this, I want to send an HTTP request from the autonomous data warehouse to…
-
Hi I am facing issue while fetching ORDS records limit more than 1000Summary: Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I …
-
Cannot figure out Why the Update Statement is not working for PUT APISummary: I am using the Update Statement produced by dragging my table into the sql worksheet as described on page https://docs.oracle.com/en/database/oracle/sql-develop…
-
To insert values from one table to anotherContent Hi team, So there is this table having 4-5 columns in which we will insert the ID and another column name, (say names) , values , into the child table where the …
-
ORDS on ATP basic Postman GET and PUTContent I am trying to perform a basic PUT from Postman to insert a record. I cannot figure out the proper syntax. I am just learning about ORDS and ATP. We have an ATP …
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there…
-
ATP Object Deployments - Hub and Spoke configurationSummary Looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and pro…
-
A working example of UTL_HTTP.REQUEST, please!Summary Please provide with a complete example of UTL_HTTP.REQUEST, which works on ATPContent I am totally stuck with my inability to make an API call from PL/SQL runnin…
-
ORDS not working at Frankfurt siteSummary ORDS not working at Frankfurt siteContent Hi, have somebody an idea why ORDS / APEX isn't working at Frankfurt site? I get the error 404 when calling the URL of …
-
Oracle Autonomous Transaction Processing Cloud Paid Option of 100GB and 1vCPU should be availableSummary Very Wide Gap between Oracle Autonomous Transaction Cloud Always Free and nearest paid optionContent There is always Free Oracle Autonomous Transaction Processin…
-
APEX - Creating page based on SaaS REST API. HTTP-400 Bad Request on update.Summary Created a page based on the SaaS Suppliers RESTful API. Retrieving row works fine, HTTP-400 when I try and update oneContent Hey folks I'm trying to create an AP…Scott Hillier-132647 8 views 0 comments 0 points Started by Scott Hillier-132647 Autonomous Database
-
APEX in ATP - Private EndpointSummary Trying to use APEX with ATP workload type autonomous databaseContent Hello everyone, we have a use case where we want to use APEX in an autonomous database, howe… -
REST web service request errorSummary REST web service request error in ATPContent when I run this query in Oracle cloud ATP ( free tier), i got this error but it works ok in ADW. select apex_web_ser…
-
Everything is broken. 503 ErrorSummary APEX, SQL Developer, Admin Reset, Restart, Stop, Start.... all do not workContent ------ EDIT: SOLVED ISSUE ------- This was not an APEX issue, but an Always-Fre…Josh Monson-227082 32 views 9 comments 0 points Most recent by Trond Enstad-230472 Autonomous Database
-
Enabling REST Data Services on ATP is failingSummary ORA-06508: PL/SQL: could not find program unit being called: "ORDS_METADATA.ORDS"Content After months of development utilizing the REST data services on our Auto…
-
503 on REST and APEX services with ACL enabledSummary When ACL's are enabled on the database the REST and APEX services are unavailableContent Hi, struggling a bit with the understanding of the ACL's. According to t…Robert Jacob-183653 20 views 4 comments 0 points Most recent by Robert Jacob-183653 Autonomous Database
-
How to connect standalone ORDS with ATP database?Summary How to connect standalone ORDS with ATP databaseContent Hello, I have created OC Instance with installed ORDS (run as standalone). I have created ATP Database, w…
-
Is ORDS authentication (first-party basic) with ATP & APEX possible??Summary When using ORDS out-of-the-box included in ATP & APEX we cannot get basic authentication to workContent Hi all, We are running into the following problem. We hav… -
ORDS CRUD Generator tool on ATP / APEXSummary I've made a CRUD Generator tool that can create an SQL script that creates a complete CRUD operation and a PATCH procedureContent I would like to share something…
-
ATP - how to access the dataSummary how to access dataContent Hi, what is recommended approach to access the data in ATP database. Using REST service what oracle cloud technology should be used. I …
-
ATP : Network Latency / ATP Db Read Replicas/ cachingSummary ATP Database / Oracle Application Container Cloud : Network Latency / ATP Db Read Replicas/ cachingContent we are using ATP database & hosted the REST service in…
-
REST JSON PUT/GET Method details to upload/download csv files in/from Object Cloud StorageSummary REST JSON PUT/GET Method details to upload/download csv files in/from Object Cloud StorageContent Please Help, we need to upload & download files from Object clo…Ranveer.Tiwari-Oracle 3 views 0 comments 0 points Started by Ranveer.Tiwari-Oracle Autonomous Database
-
ORDS module for REST API's in ATPSummary Do we get access to ORDS module out of the box in ATPContent Hi, We used to have ORDS module to quickly expose data as REST API's in Database Cloud Classic. Howe…