This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
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