title: How do i suppress the prompt in shell scripting/sql
body: <p>Below is the code used in my shell script octane.sh:</p>
  
  <pre><code>  value=$(&lt;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
  </code></pre>
  
  <p>I am using SET VERIFY OFF in octane.sql </p>
  
  <pre><code>    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 := &amp;1;
      part VARCHAR2(100);
      bill VARCHAR2(300);
      TYPE cur IS REF CURSOR;
  ........
  </code></pre>
  
  <p>It is working fine if i run the shell script as nohup./octane.sh &amp;</p>
  
  <p>But it is giving below if i schedule the cron job.</p>
  
  <pre><code>Enter value for 1: 
  SP2-0546: User requested Interrupt or EOF detected.
  </code></pre>
  
  <p>Please suggest</p>