Hi,
I have a funtion that bulk collects data into collection types and then
loops thru each collection record to do some data manipulations. I am
using the following select statement to assign some value to a
collection item in the loop.
"SELECT TRUNC((TRUNC((tt_process_end_time(i) -
tt_process_start_time(i)),5) * 100000)/60) ||'.' ||
LPAD(MOD((TRUNC((tt_process_end_time(i) - tt_process_start_time(i)),5)
* 100000),60),2,0)
INTO tt_elaspd_time(i)
FROM dual;"
When I am processing large number of records(say 20,000 +), I get
ORA-01013 error(user requested cancel of current operation). I am not
sure if it has to do something with the PL/sQL area size or in using
the dual table. By the way this is in oracle 10g. Any help with this
would be appreciated.
Thanks.
Received on Thu Jan 19 2006 - 14:12:49 CST
