如何在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

I am using SET VERIFY OFF in octane.sql

    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 job，则会出现以下错误。

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

请建议。

- Shreedhar

---

在其他set语句中添加set define off;。 - San

Answer 1

将设置定义为关闭，方法如下：

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;
........

- San