Home » Developer & Programmer » JDeveloper, Java & XML » Java Stored Procedures take longer to execute
Java Stored Procedures take longer to execute [message #196982] Mon, 09 October 2006 08:02
Messages: 1
Registered: October 2006
Junior Member
I am doing a comparison of Oracle and Java Stored procedures in terms of execution time. I have created a java stored procedure and an Oracle stored procedure both of which perform the same task. Upon execution, I find that the java procedure takes longer time to execute.
I have the following qs:-
Why is a Java Stored Procedure slower than an Oracle Stored Procedure?
How is a java stored procedure executed as compared to an Oracle Stored Procedure?
Can someone give a detailed explanation of -
- how a java stored procedure is stored in the database?
- what happens when it is executed?

Thanks in advance
Previous Topic: PL/SQL calling Java
Next Topic: PreparedStatement In Table Partition - Select * From Table Partition (?)
Goto Forum:

Current Time: Thu Feb 22 04:59:20 CST 2024