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
I need to get a NEXTVAL from a SEQUENCE in an Oracle database. The modelbuilder does have a builder.HasSequence("TABLE_SEQ"); But I have no clue on how to use
I have an issue with SQL developer where the GUI language won't change as it shows here Now I have tried the solutions where I added the following to sqldevel
Initially I was getting this exception while starting my service An attempt was made to call a method that does not exist. The attempt was made from the followi
I am using a PIVOT to combine two rows with the same ID into a single row: SELECT B1_ALT_ID, B1_CHECKLIST_1, B1_CHECKLIST_2 FROM B1PERMIT A JOIN BCHCKBOX B ON A
I am needing to create a view, and one of the columns in the view needs to calculate a value for the metric. The source table for a metric will be different dep
I need to use Oracle bitwise operation in my project. I know there is the BITAND() available for the purpose. As far as I know BITAND() is the only such opera
I've created two tables: Employees and Departments CREATE TABLE EMP ( emp_id number(3) PRIMARY KEY, dept_id Number(3) NOT NULL, emp_name Varchar2(50) NOT NU
I am trying to insert into a table, whose values are same except few from the same table with max sequnce number based on an ID. insert into ENT_ROLE_USERS_HIST
I am trying to use a simple "Drop Table" Statement in PL/SQL Developer on some tables, but they won't drop. The tables are quite large, but I've never had this
I have been stuck to get around this in Oracle SQL. I have a table that looks like following. cust_id event event_date camp_id email_ind(calculated column) 1 O
I am creating a web application where users have the option to connect to Oracle Cloud. After authenticating to Oracle Cloud, our application will call Oracle C
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production What am I missing here? When I try and create two different but similar (in my mind) pac