How to do an alter session

General Discussion
1

Hi all,
There is a nice feature in Oracle Db called EBR (Edition Based Redefinition) but in order to use it I need to do for ex :

alter session set Edition=V1;

How to do that with liquibase before create stored function or stored procedure ?

Ty for help.

2

I did a changeset sqlfile

the migrate.sql file is nice…

– *********************************************************************
– Update Database Script
– *********************************************************************
– Change Log: src/main/resources/db/v1/master.xml
– Ran at: 26/04/17 11:51
– Against: QUIZLIQUIBASE@jdbc:oracle:thin:@localhost:1521/pdb1
– Liquibase version: 3.5.3
– *********************************************************************

SET DEFINE OFF;

– Lock Database
UPDATE DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = ‘CHPRUVOS-FR (192.168.28.1)’, LOCKGRANTED = to_timestamp(‘2017-04-26 11:51:43.333’, ‘YYYY-MM-DD HH24:MI:SS.FF’) WHERE ID = 1 AND LOCKED = 0;

– Changeset src/main/resources/db/v1/06-03-2017-1.xml::editionview1::cp
ALTER SESSION SET EDITION=V1;

…

But the result is NOK

[ERROR] Failed to execute goal org.liquibase:liquibase-maven-plugin:3.5.3:update (default-cli) on project quizdbliqui: Error setting up or running Liquibase: Migration failed for change set src/main/resources/db/v1/06-03-2017-1.xml::editionview1::cp:
[ERROR] Reason: liquibase.exception.DatabaseException: ORA-00922: option erronée ou absente
[ERROR] [Failed SQL: ALTER SESSION SET EDITION=V1;]