2 Replies Latest reply: Jan 22, 2013 10:44 PM by 644479 RSS

    WHENEVER SQLERROR and 11.2.0.2.0 client

    644479
      Hi,

      Facing one issue which am not to understand further.

      One of the file say 'config.tmp' has a variable defined as follows:
      define termout = 'on';
      define SQLErrorHandling = 'continue none';
      In another sql file say 'myfile.sql' I read the above file as @config.tmp and then try to fetch the variable value as follows:
      @config.tmp
      
      execute DBMS_OUTPUT.PUT_LINE('&SQLErrorHandling');
      whenever sqlerror &SQLErrorHandling;
      set termout &termout;
      But am getting following error
      SQL> @myfile;
      continue none
      Usage: WHENEVER SQLERROR
           { CONTINUE  [ COMMIT | ROLLBACK | NONE ]
           | EXIT  [ SUCCESS | FAILURE | WARNING | n | <variable> | :<bindvariable> ]
                   [ COMMIT | ROLLBACK ] }
      SQL>
      Looks like it fails to replace the variable '&SQLErrorHandling' value. However value of '&termout' variable gets fetched.

      This issue is not seen when 11.1.0.6.0 client is used. Only when the client version is 11.2.0.2.0 am facing this issue.

      Any suggestions?

      Regards,
      Neuron

      Edited by: Neuron on Jan 22, 2013 3:03 PM

      Edited by: Neuron on Jan 22, 2013 3:05 PM