Skip to Main Content

ODP.NET

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.jpg
But 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 User_M80CR on Feb 23 2021
Jump to Answer
Comments
Post Details
Added on Feb 22 2021
2 comments
122 views