PL/SQL (MOSC)

MOSC Banner

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;

-- ***********************************************************************

-- ***********************************************************************

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center