如何在shell脚本/sql中禁止提示

Question

下面是我的shell脚本octane.sh中使用的代码：

  value=$(<max.txt)
    echo "$value"
    fldr=`date +%d%b%Y`
    SCRIPT_HOME=/oradata/ora_backup/report/summary/OCTANE/
    $SQLPLUS -s $USER/$PASSWD@$ORACLE_SID  @/oradata/ora_backup/report/summary/OCTANE/octane.sql $value

我在octane.sql中使用SET VERIFY OFF

    set serveroutput on;
    set heading off;
    set echo off;
    set feedback off;
    set linesize 1000;
    SET VERIFY OFF;
    spool /oradata/ora_backup/report/summary/OCTANE/birlasm.sql
    set serveroutput on
    DECLARE
    sqltxt VARCHAR2(3000);
    IDS number := &1;
    part VARCHAR2(100);
    bill VARCHAR2(300);
    TYPE cur IS REF CURSOR;
........

如果我以nohup./octane.sh &的身份运行shell脚本，它就可以正常工作。

但如果我安排cron作业，它会在下面给出。

Enter value for 1: 
SP2-0546: User requested Interrupt or EOF detected.

请给出建议

Answer 1

Add set定义off，如下所示：

set serveroutput on;
set heading off;
set echo off;
set feedback off;
set linesize 1000;
SET VERIFY OFF;
set define off;
spool /oradata/ora_backup/report/summary/OCTANE/birlasm.sql
set serveroutput on
DECLARE
    sqltxt VARCHAR2(3000);
    IDS number := &1;
    part VARCHAR2(100);
    bill VARCHAR2(300);
    TYPE cur IS REF CURSOR;
........