I'm trying to figure out on how to create an Index for below query such that the SELECT statement only traverse the leaf level of the index horizontally and it
I am polling clob column using apache camel as below. <route> <from uri="timer://timer1?period=2m" /> <setBody>
I'm new to Oracle AWS RDS, we have a RDS deployed and an S3 bucket. The download from S3 works fine, however I wanted to write a script which checks if the file
When I install Oracle 19C on my vmware windows 10 it. Show like in photo. How to fix it. Thanks all of you for help. enter image description here
I have problem with login in enterprise manager. I have windows 10 Education.Database successfully installed but still unable to log into http. Po wydaniu polec
I want to dequeue message with message id from my queue table, but I get error that ORA-25263: no message in queue OPERATION_QUEUE with message ID DBF9DE01CB5C0
does any one have any material to recommend me on how to properly create a good CRUD code to handle python with oracle? I am doing some basic query/insert/updat
Goodday everyone. Faced strange OOM after switching from reading varchar field to clob from Oracle database in java application. (We are using oracle.jdbc.drive
I have a task to import some data from Postgres database to Oracle via dblink The connection between Postgres and Oracle works good, but unfortunately, when I t
Good day, everyone! I've got a bunch of sequences. For example: CREATE SEQUENCE seq_id INCREMENT BY 1 START WITH 1 MINVALUE 1 MAXVALUE 20000
I'm trying to select user role from Oracle database using id of user in spring boot framework but it not working? I'm trying to select user role from Oracle
I have a requirement to change the owner of an interactive report and also change the interactive report from public to private. I am aware of the APEX_IR.CHANG
I have a c# MVC web application (.NET 4.52) using an older version of Devart LinqConnect to scaffold the database etc. The app has been around for 10 years wit
I have tried to configure an AWS DMS Endpoint, but when I try to do the connection test it shows me the following error: Test Endpoint failed: Application-Stat
In the code base I am working with we use the oracle instant client library as a third party dependency in Bazel as follows: cc_library( name = "instant_cli
i have a procedure that give me a refcursor as out parameter and i have to join that data with other tables in my own package. i try to fetch cursor in a variab
I'm creating an ASP.NET API Core application, to handle API services, which communicate to an Oracle Database. At runtime, when the process tries to connect to
I'm writing a Python script with CX_ORACLE which will take about 20K files and upload them into a BLOB column. They are PDFs,CSVs,TXTs, and JPGs. I'm just not u
Are there open-source solutions to share Oracle connection pools across server instances so application instances don't suck up limited connections? For example
My user has the following privileges: `GRANT CREATE SESSION to user1; GRANT SELECT ANY TABLE to user1; GRANT SELECT_CATALOG_ROLE to user1; GRANT SELECT ANY DICT