current function in long running strored procedure
HOW can I GET the real current time in stored procedure call?
These test program proofs that the built-in current function in a stored
procedure the procedure returns the time when the procedure BEGAN not
the CURRENT time!
create procedure test() returning datetime year to second;
define i int;
for i= 1 to 5
return current do with resume;
system( 'sleep 3' );
end for;
end procedure;
The execute procedure test()
returns
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53
1998-07-13 11:33:53