Database Administration (MOSC)

MOSC Banner

PLS-00103: Encountered the symbol "ALTER"

edited May 20, 2022 7:53AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi,

On 19c on AIX

This is my code:

BEGIN

IF $$ORACLE_SID="myCDB" THEN

alter session set container="myPDB";

END IF;

END;

And I receive:


alter session set container="myPDB";

*

ERROR at line 4:

ORA-06550: line 4, column 1:

PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:

( begin case declare exit for goto if loop mod null pragma


Thanks.

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