Skip to main content

All Questions

Tagged with
Filter by
Sorted by
Tagged with
1 vote
1 answer
195 views

Troubleshooting oracle database errors from cloud application

I am trying to troubleshoot an issue that presents as different database errors such as, ORA-01000: maximum open cursors exceeded or Unable to create DB Connection. I have reviewed the PLSQL to ...
Gloria Santin's user avatar
1 vote
2 answers
560 views

Connection denied from Java application

I try to connect from my little Java class to Oracle11g database and connection was refused with a SQL error. From client (SQL Developer) connection works. This is the ERROR when I try to run java ...
Federica Forte's user avatar
0 votes
1 answer
1k views

How to determine if the error was a deadlock?

The following transaction has been selected as a victim of a deadlock: public void side2() throws SQLException, InterruptedException { TestConnectionPool connectionPool = new TestConnectionPool();...
AlexC's user avatar
  • 309
2 votes
1 answer
9k views

How to drop invalid Java classes from Oracle?

I tried to load some jars into my database, but I think I messed up something, because I tried as DBA and then with some oracle user... This was my first command: call dbms_java.loadjava('-genmissing ...
VORiAND's user avatar
  • 163
3 votes
2 answers
6k views

Replicate or Call java encryption function in Oracle pl/sql

I am trying to replicate encryption/decryption method present in java in Oracle DB, so that data encrypted in java can be decrypted through Oracle Function. Below is java code: package com.encr; ...
Vikram V's user avatar