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)