Sequences in PL/SQL Expressions
(Doc ID 433068.1)
Last updated on FEBRUARY 03, 2022
Applies to:
PL/SQL - Version 11.1.0.6 and laterInformation in this document applies to any platform.
Purpose
The purpose of this note is to introduce the 11g new feature that allows sequences in PL/SQL expressions.
With Database versions prior to 11i, the following errors may appear:
PLS-00357: Table,View Or Sequence reference 'EMPLOYEES_SEQ.NEXTVAL' not allowed in this context
PLS-00357: Table,View Or Sequence reference 'EMPLOYEES_SEQ.CURRVAL' not allowed in this context
Scope
This note is intended for PL/SQL developers.
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Purpose |
Scope |
Details |
11g New Feature: Sequences in PL/SQL Expressions |