/*
  utPLSQL - Version 3
  Copyright 2016 - 2017 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.
*/
set serveroutput on size unlimited format truncated
whenever oserror continue

set heading off
set linesize 1000
set pagesize 0

set verify off
set define on

set termout off
set timing off
set feedback off

column line_separator new_value line_separator noprint
select '--------------------------------------------------------------' as line_separator from dual;

column 1 new_value 1 noprint
select null as "1" from dual where 1=0;
spool params.sql.tmp
select
  case
    when '&&1' is null then q'[ACCEPT ut3_owner CHAR DEFAULT 'UT3' PROMPT 'Provide schema for the utPLSQL v3 (UT3)']'
    else 'define ut3_owner=&&1'
  end
from dual;
spool off
set termout on
@params.sql.tmp
set termout off
/* cleanup temporary sql files */
--try running on windows
$ del params.sql.tmp
--try running on linux/unix
! rm params.sql.tmp
set termout on
