68 questions
0
votes
0
answers
22
views
Oracle ORDS JDBC connection using OCI driver and IPC (inter process communication)
I noticed that even a minimal query which takes around 0.3 milliseconds to execute, still results in a ~20 millisecond ORDS call as measured in the access log.
I was wondering if a little bit of ...
- 3,985
0
votes
0
answers
40
views
JSON_OBJECT_T stringify CLOB is unable to stringy for huge data
I'm using the PLSQL procedure to return the data from the table and the ORDS will convert the CLOB to string using stringify function but the stringify is failing if i'm trying to conver huge data ...
- 99
0
votes
1
answer
71
views
ORDS PL/SQL block is unable to parse the input JSON and merge or delete the records
I'm trying to create one ORDS REST API in my 19c oracle ATP database, i.e. to accept the JSON input payload in my RESTG request (POST HTTP method) and try to insert, update, delete the header ...
- 99
0
votes
0
answers
173
views
OAuth 2 token getting error 401 unauthorized even after providing right credentials and token URL (Oracle APEX REST API)
In the restful services I created custom role (named "client_auth_custom") and assigned that to a module through privilege (also named "client_auth_custom").
The API Module URL is: ...
- 27
0
votes
0
answers
54
views
Alternate to data fetching through DB Link stored procedures when migration to Oracle cloud database
What are the best alternate approach to data fetching through DB Link stored procedures when migration to Oracle cloud database. Currently our reconciliation application is fetching data from oracle ...
- 9
0
votes
1
answer
77
views
TLS and Oracle API for MongoDB
I'm using the Oracle API for MongoDB with Oracle REST Data Services as described here:
https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/24.3/ordig/oracle-api-mongodb-support.html
...
- 513
0
votes
2
answers
1k
views
APEX 24 doesn't work with ORDS 24 deployed on tomcat. ORDS itself is available with tomcat
Problem
ORDS 24 is working and is avaiable through tomcat under http://localhost:8080/ords/, which gets redirected to http://localhost/ords/_/landing. However the APEX installation is not avaiable:
I ...
0
votes
3
answers
58
views
Nested stucture in ORDS WS response
We're writing WS with ORDS (Oracle Rest Data Services) and we are able to have simple (flat) json responses. ORDS automatically convert my SYS_REFCURSON in json, for example:
{
"title": &...
- 73
0
votes
1
answer
43
views
unbale to get the data from ORDS plsql block if input is an json array of objects
I'm using below PLSQL block within my Oracle ORDS where my current input json body is like below
['123','456']
but i want to change the input json body to below format (unable to decide the logic)
[{
...
- 99
0
votes
0
answers
178
views
Oracle REST Data Services (ORDS) token refresh endpoint returning 404 Not Found
ORDS version: 22.4
Database version: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0
Database schema: apitest
I am trying to refresh the Oauth2 bearer token via the API endpoint but it ...
- 91
2
votes
2
answers
60
views
Always Free Oracle Autonomous Database Soda not find database
I am testing the Oracle Autonomous Database json soda using this tutorial:
Use SODA for REST with Autonomous Database
All works well until I test the OAuth @ "Use SODA for REST with OAuth Client ...
- 4,301
0
votes
1
answer
307
views
Retrieving HTTP POST Request Body in an APEX application when coming from External Application
I am attempting to develop a Requisition application in Oracle APEX using the cXML Request/Response standard with an external supplier partner. The process starts in APEX by building a cXML request to ...
0
votes
1
answer
1k
views
Oracle: Error when compiling any stored procedure . WaitCursor.hide called without matching WaitCursor.show sql developer
I created a new Oracle RDS from an existing snapshot. But when I try to compile any existing procedure I get this error on SQL Developer :WaitCursor.hide() called without matching WaitCursor.show().
...
0
votes
0
answers
38
views
ords 24.1 error/session crash when getting Hebrew chars as input
I am trying to use ords24.1 for plsql cartridge app. I can view data in Hebrew chars, but trying to input Hebrew characters, the HTTP session is broken with http 504 and I get this error on the ...
0
votes
0
answers
179
views
Oracle ORDS GET handler with associative array as input parameter
I would like to create a handler using http GET to invoke the following PL/SQL procedure
create or replace PROCEDURE test_array (
ait_string IN dbms_sql.varchar2_table,
query_result out ...
- 93