Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to use AS OF TIMESTAMP Clause Parameter as Variable instead of TIMESTAMP Literal?

User_M80CRFeb 22 2021

Hello Support,
In the attached PL/SQL File [ZIP format] I have created the AS OF TIMESTAMP Clause Demo using Parameter instead of TIMESTAMP Literal from the following demo provided by Jonathan Gennick at the following web-site
Flashback_Demo.jpgBut I get the following error during PL/SQL compile process as shown below:
AS_OF_TIMESTAMP_Parameter.jpgCan you please let me know how to provide parameter instead of TIMESTAMP Literal within AS OF TIMESTAMP Clause?
Test_Flashback_Query_Parameter.zip (783 Bytes)

This post has been answered by Jonathan Lewis on Feb 23 2021
Jump to Answer
Comments
Post Details
Added on Feb 22 2021
11 comments
1,642 views