Skip to Main Content

Oracle Database Discussions

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!

I need to set the Default Edition inside a PLSQL Procedure

Sky13Jul 7 2021 — edited Jul 7 2021

Hello, I am using EBR on Oracle 19c. I have created an Editon and need to set the Default Edition inside a Procedure. I am trying to use:
execute immediate 'alter database default edition = TEST_01';
But I get this error:
ORA-02231: missing or invalid option to ALTER DATABASE
It is acting as if I am not giving an Edition Name to use.
Any help would be great.

Comments
Post Details
Added on Jul 7 2021
1 comment
172 views