create table ut_output_buffer_tmp(

/*

utPLSQL - Version 3

Copyright 2016 - 2021 utPLSQL Project

Licensed under the Apache License, Version 2.0 (the "License"):

you may not use this file except in compliance with the License.

You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software

distributed under the License is distributed on an "AS IS" BASIS,

WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

See the License for the specific language governing permissions and

limitations under the License.

*/

/*

* This table is not a global temporary table as it needs to allow cross-session data exchange

* It is used however as a temporary table with multiple writers.

* This is why it has very high initrans and has nologging

*/

output_id raw(32) not null,

message_id number(38,0) not null,

text varchar2(4000),

item_type varchar2(1000),

is_finished number(1,0) default 0 not null,

constraint ut_output_buffer_tmp_pk primary key(output_id, message_id),

constraint ut_output_buffer_tmp_ck check(

is_finished = 0 and (text is not null or item_type is not null )

or is_finished = 1 and text is null and item_type is null ),

constraint ut_output_buffer_fk foreign key (output_id) references ut_output_buffer_info_tmp(output_id) on delete cascade

) organization index nologging initrans 100

overflow nologging initrans 100;

create sequence ut_output_buffer_tmp_seq cache 20;