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

Report message to a moderator

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.

Report message to a moderator

Previous Topic: how to create chart in iframe?
Next Topic: Linking Pages in Interactive Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 30 22:21:48 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.