All Questions
Tagged with java-stored-procedures oracle11g
12 questions
2
votes
0
answers
2k
views
Oracle 11g, HTTPS connection with Java stored procedure using TLSv1.2
I have two separated servers running Oracle 11g.
The servers were patched with Oracle patch sets to upgrade JVM. After the upgrade, I'm able to communicate with external web service using HTTPS and ...
- 547
-1
votes
1
answer
168
views
Character/String passed from java to stored procedure does not work
Hi I have a stored procedure which accepts parameter "Q_RES" from java. Its value is either "Y" or "N" . In my stored procedure I have a condition
If Q_RES = 'Y' THEN
sp_stat = 'TABLENAME.RES ...
- 273
0
votes
1
answer
18
views
Java stored procedure running infinitely
I'm calling a java stored procedure from oracle. After i called execute() method it is never coming out of SP execution and locking the tables. But after i stop the server, the records are getting ...
- 38
0
votes
1
answer
383
views
Oracle 11g: execution completed with warning
I'm compile the source code below using oracle sql developer:
import javax.crypto.Mac;
import javax.crypto.spec.SecretKeySpec;
import org.apache.commons.codec.binary.Base64;
public class ...
- 699
1
vote
0
answers
519
views
how to call stored procedure having input as integer array parameter using hibernate
I have created a TYPE of integer array named as 'INTARRAY'.
Later I created a procedure taking input as integer Array.
Procedure: SP_SET_MENU(roleId IN INTARRAY)
Now in my java application using ...
0
votes
1
answer
2k
views
Handling exceptions in Oracle DB stored Java classes
When a stored Java class hits and unhandled exception, what is the best way to get the full stack trace back to PL/SQL for proper logging?
During preliminary tests of my class, I hit a NullPointer, ...
- 336
3
votes
1
answer
597
views
Oracle Java stored librairies won't compile
I'm looking to store Java libraries inside my Oracle database. Note that this is the first time I'm doing that. That library is pd4ml. It is made up of two jars, which contains the compiled classes.
...
- 336
3
votes
1
answer
8k
views
BCrypt implementation in Oracle
I am trying to save the user password using Bcrypt algorithm in Oracle 11g. I know this can be done in Java easily, but in this case i want to do this in DB side. Can any one help me in achieving this....
- 51
0
votes
2
answers
1k
views
Can Oracle DBMS return a Java object from a Java stored procedure call?
Can the Oracle database return a Java object from the return values of a Java stored procedure call?
I would like to query the Oracle database with a call to a java stored procedure and receive back ...
- 385
4
votes
1
answer
4k
views
Spring StoredProcedure Optional Parameters
I have a procedure in Oracle that has 12 total parameters and 3 optional. How can I account for these optional parameters if I'm using the StoredProcedure object in Spring 3.1.0?
Here's what I have ...
- 1,638
7
votes
4
answers
4k
views
java.lang.ArithmeticException when attempting to get connection in Oracle 11.2.0.2.0 (64 bit)
I'm currently working with Java Stored Procedures in Oracle and am seeing some strange behaviour when attempting to get a connection within my Java code.
My Java is packaged up into a jar file and ...
- 15.1k
1
vote
3
answers
630
views
JDK 6: Is there a way to run a new java process that executes the main method of a specified class
I'm trying to develop an application that just before quit has to run a new daemon process to execute the main method of a class.
I require that after the main application quits the daemon process ...
- 2,450