Hi there, I am facing an issue wherein i need to have more than 1000 values in IN Operator of query. Please suggest some way around for the same .here is the code snippet for you. Note: RMID IN can have 1000+values .Also had tried using OR RMID IN ()-for values greater than 999 i...

I thought I could take what Chris showed me in my original question (https://asktom.oracle.com/ords/asktom.search?tag=looking-for-help-with-json-object). However, after 2 days, I have not made any progress. The JSON data - { "recall_control": [ { "item_id":"item1",

Hello, I am executing a package on multiple threads. Our package is for deleting data in bulk. Whenever I am running the package on multiple threads I am getting a deadlock. On checking the trace file I found the delete statement which is causing deadlock. But the graph shows as ...

Hello, We have migration project form Oracle database 11g in Exadata server, to 19c in ODA server, when we tested the query in the new server with client tool such as Sql developper, Sqlplus and Sqlcl, the connection was lost after 1 hour of inactivity, the only difference betwee...

Tom, How can we display PDF files stored in the database, using htp.p (OAS PL/SQL cartridge )calls and dbms_lob ? We are developing a document archival and display app. Using ctxload, I can upload the files. Now, I would like to display the file in its native format (PDF) on the ...