This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes Java in General and the fly likes Stored procedure Vs Java prg Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Java in General
Bookmark "Stored procedure Vs Java prg" Watch "Stored procedure Vs Java prg" New topic
Author

Stored procedure Vs Java prg

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Hi,
An application which queries a lot the DB to process around 10k records individually and at the same time it also needs some IO operations. I guess it may take around 1 hr. in Java.
Which kind of approach better best suits to do this job.
If its a stored procedure, how flexible is it enough to handle IO,string and amount calculation for a non-PL/SQL programmer.
Does Oracle 9i supports executing Java classes from stored procedure. Is it good prg. practise.
Advise on it.
Thanks,
Anil


SCJP 1.5, SCEA, ICED (287,484,486)
Sean MacLean
author
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
Oracle actually allows you to load, compile and run Java classes directly in the database, so I image that you can call such classes from stored procedures. This area of their site might provide some insight.
http://otn.oracle.com/tech/java/java_db/content.html
Sean
 
GeeCON Prague 2014
 
subject: Stored procedure Vs Java prg