Hi,

I am trying to check the performance monitoring of a procedure. For that
at various levels in the procedure, I am writing to an external file. I
am also logging the time the insert statement was fired to write into
the external file using current_timestamp system variable. However all
the records into the external table the timestamp value doesn't vary at
all. All the values appear the same.



The following is the external table query

create table portfolioextern external file

'd:\temp\portfolioextern.txt'

(ID CHAR(16),operationcompleted char(64), PROCNAME VARCHAR(32), LOGDATE
CHAR(30))



The sample insert query that is fired within the procedure at various
levels in it.

INSERT INTO PORTFOLIOEXTERN VALUES

('123456789012','TESToperation','TESTPROC',CURRENT_TIMESTAMP)



All the values in the LOGDATE column are same though the procedure takes
an hour plus to complete.



Regards,

Mahendra Nepali

Desk: +91-22-67184586

Mobile: +919820191887

Email: mahendra.nepali@...





DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.


[Non-text portions of this message have been removed]