Hi,
I have a big problem, i wrote a very long function that is taking so much time. inside this function i added few debugging steps to find which section is taking most of the time, but all the created records have the same time in them, the time where the fuction begins.
I tried to different methods:
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), now());
INSERT INTO f_error (error_id, creation_date)
VALUES (nextval(''s_f_error_id''), ''now'');
Tanks in advance for your help.