File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Stored procedure Vs Java prg

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
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.

SCJP 1.5, SCEA, ICED (287,484,486)
Sean MacLean
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.
I agree. Here's the link:
subject: Stored procedure Vs Java prg
It's not a secret anymore!