ORDS and REST
Discussion List
-
dbms_cloud.list_objects not returning data as other user than ADMINSummary: As ADMIN dbms_cloud.list_objects returns a list of objetcs; As other DB user with same credentials not returning data and not returning errors. Content (please …Stéphane Lamy-Bouchard 21 views 4 comments 0 points Most recent by Stéphane Lamy-Bouchard Autonomous Database -
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the… -
Authorization failed while exporting to Object storage from ATPSummary: Hi I am getting authorize failed error while exporting data from ATP to bucket using dbsm_cloud.export_data package. ORA-20401: Authorization failed for URI - h…
-
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is…
-
ORDS - Issue with OAUTH Implicit grant - Missing or Incorrect Client idSummary: An ORDS client has been created in an ATP database as following. When doing the 1st step of the schema sign-in/authentication get the 400 Bad request message On…
-
Connect to ATP Database from ExcelSummary: Want to connect to ATP Database from Excel Content (required): Hi, Found below note to connect to ATP DB from Excel, but we don't find option to download 'Add-i…
-
ATP in private subnet, how to allow access of APEX & ORDSSummary: Hi Team, We are planning to provision ATP for a client and private subnet, so it will have a private endpoint. so how to do access APEX, ORDS and database actio…
-
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…
-
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…
-
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 52 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 is this mi…
-
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 37 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 41 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 30 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…