All Questions
Tagged with oracle-rest-data-services plsql
12 questions
0
votes
0
answers
41
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
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
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
1
vote
1
answer
1k
views
ORA-20001: Authentication failed when calling external api in oracle apex
I am currently trying to consume a external api through Oracle apex. I was able to call below api by hard coding 'Baerer' taken but, at the line no 5, it throws an error
ORA-20001: Authentication ...
- 603
0
votes
1
answer
1k
views
How to write pl/sql source in get restful service handler in oracle apex?
Above one is working perfectly in oracle apex. But I want to execute different query based on the id.
Please suggest me the correct way. I think the screenshots are enough to present my requirements. ...
- 936
1
vote
0
answers
488
views
ORDS: Error 401--Unauthorized From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1: 10.4.2 401 Unauthorized
w.r.t. Oracle REST Data Services (ORDS) : Authentication
And microservices-the-easy-way-with-ords-and-micronaut-part-1
Using PLSQL,
Through below code on SQL developer when tried, I received ORA-20001:...
- 85
0
votes
1
answer
655
views
Oracle Apex - OAuth token generated in HTML format
On a complete new environment I have created restful services.
Using PLSQL,
Through below code on SQL developer when tried, I received ORA-20001: Authentication failed.
BEGIN
APEX_WEB_SERVICE....
- 85
0
votes
1
answer
292
views
Secure every endpoint ending with */private in Oracle REST-Data-Services
I am using Oracle Rest-Data-Services to export several PL/SQL-APIs as webservice using REST. Therefore every PL/SQL-Package is an ORDS-Module and should have a template ending with */private that has ...
- 76
2
votes
2
answers
331
views
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
...
- 1,475
0
votes
0
answers
928
views
Any limitation on ORDS post API data volume?
I am trying to send a POST request of huge block of JSON to ORDS but always getting 500 - Internal server error.
If I reduce the value to around 2000 the POST API works successfully. I am using a ...
