All Questions
251 questions
0
votes
0
answers
75
views
StoredProcedureQuery does not end
We are trying to call a PL/SQL Procedure that runs in a Oracle Database. The complete PL/SQL procedure runs for 10-12 minutes.
With SpringBoot 3.x with Java 21, we use Hibernate to call this Stored ...
0
votes
0
answers
149
views
Materialized view with REFRESH ON COMMIT is not working in ORACLE 19
I am trying to create materialized views and materialized view log but the materialized views are not getting refreshed even after the use of REFRESH ON COMMIT in ORACLE 19. The same code for the ...
- 1
1
vote
1
answer
62
views
Jdbc loses parameter while calling Oracle stored procedure
I have following jdbcCall:
SimpleJdbcCall simpleJdbcCall = simpleJdbcCallFactory.create()
.withProcedureName("MY_PROCEDURE")
.withReturnValue()
...
- 549
0
votes
1
answer
208
views
initiateAnalysisExport () Method with OBIEE web services not returning queryID
I'm trying to use the webservices API in OBIEE with the initiateAnalysisExport() method of the AnalysisExportViews service in OBIEE 12C. I can send the API request without any issues, but the ...
- 31
1
vote
1
answer
54
views
Unable to set custom clientInfo in Oracle
I am using oracle 12 c and want to add custom client info to the connection object. Here is the code in Java 8.
connection.setClientInfo("USER.USERID",user);
But it get error
ORA-28267: ...
- 11
1
vote
0
answers
39
views
Some inserts are not appearing in DB table
I am trying to insert the records after reading them from a file. There are bunch of files, I read/parse one file at a time and insert all the records from that file at a time. This works fine in most ...
- 43
1
vote
0
answers
432
views
Translation of empty array element in XML to JSON became null in Oracle Service Bus Pipeline
I'm facing an issue when working with Oracle Service Bus. I want to translate XML to JSON as the response but when using nxsd in OSB pipeline to do that translation the empty array (<in:<...
0
votes
0
answers
72
views
Query with params
I have a DB code:
type T_Sk is record
(
code Integer,
dat Date,
...
);
type TBL_Sk is table of T_Sk;
function FN_Sk(ADetId in Integer, ATrudoForFac in Integer, ATrudoForCex in Integer) return ...
- 51
0
votes
1
answer
3k
views
Error while installing JDeveloper 12c 12.2.1.4
I want to install Oracle JDeveloper 12c (12.2.1.4.0) Studio Edition. But I am facing some problem. I can't install the software. I have tried the Generic Version, windows 64bit as well as 32bit. But ...
0
votes
0
answers
105
views
JPS-04201: Cannot grant permission(s). Grant already exists for grantee [GranteeEntry]
How to solve the above error thrown during system policy creation in weblogic server using codebase.
- 9
0
votes
2
answers
292
views
Conditional Required field in Oracle ADF 12c
I have a form that requires multiple user inputs. One of them is a drop down list from which the User has to choose. Now I have to set the next input field as required depending on the options chosen ...
- 1
1
vote
0
answers
1k
views
Oracle Database Change Notification Not Working For JDBC
I am using Java 8 and using oracle version as the Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.
We are using below driver to connect to the database.
<dependency>
<...
- 629
0
votes
1
answer
1k
views
unable to execute oracle data setup script from docker compose
I am trying to set up oracle data once my oracle container is up and running, below is my compose file:
version: '3'
services:
oracle:
image: absolutapps/oracle-12c-ee
container_name: oracle-...
- 122
2
votes
0
answers
2k
views
Configure spring boot with Oracle DB SSL/TCPS
I need to configure Spring boot with TCPS for Oracle DB, I've found an article for normal java program but couldn't find any resources for spring boot configuration
Properties props = new ...
4
votes
1
answer
4k
views
Can setting higher value of JDBC fetch size affect the database performance?
We have a simple select query with only single column in SELECT clause. No WHERE clause condition (cause application demands this). Query fetches around 5000000 rows at a time. DBAs sometimes see a ...
- 2,821