aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
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
 
 
subject: Stored procedure Vs Java prg