Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » SYSDATE in success message (10g xe apex 2.1)
SYSDATE in success message [message #528423] Mon, 24 October 2011 17:47 Go to next message
hudo
Messages: 165
Registered: May 2004
Senior Member
How can I use SYSDATE in the 'Process Success Message' of a plsql block ?
I want a message like: Procedure executed at 25.10.2011 00:24:25
Re: SYSDATE in success message [message #528457 is a reply to message #528423] Tue, 25 October 2011 02:02 Go to previous message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
What you can do is assign a to_char of sysdate with your chosen format to a page item, e.g. P10_PROCESS_DATE. Then in your success message you can use: Procedure executed at &P10_PROCESS_DATE.
Previous Topic: how to create chart in iframe?
Next Topic: Linking Pages in Interactive Report
Goto Forum:
  


Current Time: Tue Sep 22 16:59:04 CDT 2020