It's not a secret anymore!
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!