How to use AS OF TIMESTAMP Clause Parameter as Variable instead of TIMESTAMP Literal?
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
But I get the following error during PL/SQL compile process as shown below:
Can you please let me know how to provide parameter instead of TIMESTAMP Literal within AS OF TIMESTAMP Clause?
Posted the code as shown below [Time_Instant_Param is the parameter I want to use] :
set serveroutput on size 30000;
SET DEFINE OFF
DECLARE
Snapshot_Instant_Test TIMESTAMP;
-- ***********************************************************************
-- ***********************************************************************