Stack Overflow
Stack Overflow

Questions tagged [oracle-rest-data-services]

Use this tag for questions specifically about the Oracle ORDS product. Don't use it for questions about Oracle Application Express, a.k.a APEX, or questions about generic web services communicating with an Oracle database.

Oracle REST Data Services (ORDS) bridges HTTPS and your Oracle Database. As a mid-tier Java application, ORDS provides a Database Management REST API, SQL Developer Web, a PL/SQL Gateway, SODA for REST, and the ability to publish RESTful Web Services for interacting with the data and stored procedures in your Oracle Database. The ORDS documentation may be found here.

48 questions
3
votes
0 answers

Accurate representation of complex data types in OpenAPI 3.0 documentation using Oracle Rest Data Services (ORDS)

I'm using Oracle Rest Data Services (ORDS) and I want to return a complex data type. For example, a 'Customer' with their corresponding 'Addresses'. I can manually construct and return the JSON for this, which is not a problem. I can also create…
Jens k
  • 109
  • 1
  • 5
2
votes
2 answers

Dynamic SQL with dynamic bindings in PL/SQL

I'm writing a REST handler in ORDS. The URL endpoint should allow queries to be made with a number of optional parameters. One way to write the PL/SQL code could be: DECLARE cur SYS_REFCURSOR BEGIN OPEN cur FOR SELECT * FROM MYTABLE WHERE …
David Min
  • 1,246
  • 8
  • 27
2
votes
2 answers

Apache can't reach Tomcat: AH00957, AH00959 & AH00896

I have Tomcat 7.0.105 installed with ords.war deployed in it. In my browser, I use the URL http://rtp, where rtp is the name of my server as defined in /etc/hosts. This uses port 80 and reaches Apache on the server. There I have a conf file in my…
Rob van Wijk
  • 17,555
  • 5
  • 39
  • 55
2
votes
2 answers

ORDS_INTERNAL package can not be compiled during/after ORDS 19.0.4 installtion

In one of our oracle 11g databases we get following error during ORDS 19.4.0 installation. [*** script: ords_internal.plb] Package Body ORDS_INTERNAL compiled LINE/COL ERROR ---------…
Bulent Basim
  • 21
  • 2
1
vote
0 answers

Oracle APEX and REST Data Services: No provider found for: requires oracle.dbtools.url.mapping.URLMapping

I am trying to install APEX_230100 and ORDS 23.2 on FREEPDB1 on ol8 on docker on MacOS but without luck. Both APEX and ORDS are installed successfully... Now when firing up ords in standalone mode: [oracle@81244fe391d1 ~]$ ords --debug --config…
Bjarte Brandt
  • 4,191
  • 2
  • 23
  • 25
1
vote
1 answer

How to revoke an accesstoken?

I'm developing a login with Angular exposing my database functions via ORDS. At the moment I generate an accessToken to display my database views exposed via web API, and I use the following cmd command: curl -i -k --user :…
En D.
  • 13
  • 3
1
vote
1 answer

Install Rest Data Services not available in SQL Developer version 22

I am trying to configure ORDS in my SQL Developer (version 22.2). According to the documentation I should be able to do this from the menu: Tools -> REST Data Services -> Install. Documentation Unfortunately this option is not available for…
Laura Constantinescu
  • 13
  • 3
1
vote
1 answer

Oracle ORDS: Get request returns old data, then after period of time the changed data

I am having a problem with the Oracle Rest Data Services (short ORDS) and I can't find a solution. The Problem is as follows: We are using ORDS via a TomCat Webserver and I have 2 Endpoints defined, one to Update a dataset and one to get all…
Julian
  • 13
  • 2
1
vote
0 answers

Oracle ORDS Data Service PL/SQL Procedure cannot return more than 32767 Characters to CLOB Out parameter called from Python or Postman

ORDS.DEFINE_HANDLER( p_module_name => 'EMRPRJWSTV1.0', p_pattern => 'getPriceConfigDetails', p_method => 'GET', p_source_type => 'plsql/block', p_mimes_allowed => NULL, p_comments => NULL, …
Kamlesh Dhairyavan
  • 5
  • 1
1
vote
0 answers

How to enable cache in ORDS?

I have ORDS deployed on a windows machine behind an Oracle Apex application. I would like to enable cache on ORDS. I tried the following but nothing is happening. ORDS is not caching anything and the cache directory specified in the configuration…
Thomas Carlton
  • 5,344
  • 10
  • 63
  • 126
1
vote
0 answers

Issue with Oracle APEX Report Printing using External ( Apache FOP ) Print Server

Our current development environment includes release Oracle APEX 21.1 with ORDS 21.x, Weblogic Application server and Oracle 19c. We have mounted customized version of Apache FOP 2.6 web application (fop.war) on to the application server to print…
kapiell
  • 697
  • 7
  • 23
1
vote
0 answers

ACL information for connecting rest services

I am new to Oracle APEX, i am trying to create Rest Data Source in Oracle APEX but i am getting an error which is attached screenshot, enter image description here So i have checked with my DBA, he want some information like below. ACL Name: lower…
Yokeswaran Gandhimohan
  • 9
  • 4
1
vote
1 answer

How to pass role information while creating an user in Oracle cloud app using Create User API

I am using below endpoint to send JSON request body to create an user in oracle cloud application https://servername.fa.us2.oraclecloud.com/hcmRestApi/scim/Users I am able to create an user, If I don't pass option "roles" json array element in…
Swapnil
  • 11
  • 3
1
vote
2 answers

ORA-01017 During APEX ORDS installation

I'm trying to install oracle ORDS on tomcat following this document: https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-installation-on-tomcat When I start this script $ $JAVA_HOME/bin/java -jar ords.war I got ORA-01017 and prompt…
Pavlos
  • 13
  • 8
0
votes
0 answers

ORDS not able to write to db

The application is using Weblogic, ORDS(Oracle REST Data Service). I see this error while trying to write to the db. Has anyone experienced it? These exceptions come for any insert/update queries done in the code but not for select queries. Read…
Coder12345
  • 179
  • 3
  • 11
1
2 3 4