This variation of the CREATE SCHEMA command creates a new schema owned by username and populated with one or more objects. The creation of the schema and objects occur within a single transaction so ...

EXECUTE IMMEDIATE 'SELECT EVENT_JOURNAL__ORDERING_SEQ.nextval FROM dual' INTO l_value; EXECUTE IMMEDIATE 'ALTER SEQUENCE EVENT_JOURNAL__ORDERING_SEQ INCREMENT BY ...