2 Replies Latest reply on May 3, 2019 2:13 PM by jpbenezet

    SQLcl issue with /*ansiconsole*/

    jpbenezet
      SQLcl : version 19.1 Production sur lun. avr. 29 14:16:05 2019
      
      Copyright (c) 1982, 2019, Oracle. Tous droits rÚservÚs.
      
      ConnectÚ Ó :
      Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
      With the Partitioning, Oracle Label Security, OLAP, Data Mining
      and Real Application Testing options
      
      CREATE TABLE DATA
      (
        key VARCHAR2(10 CHAR),
        val VARCHAR2(500 CHAR)
      );
      
      
      SQL> select /*ansiconsole*/ * from DATA;
      avr. 29, 2019 1:21:02 PM oracle.dbtools.raptor.newscriptrunner.ScriptExecutor run
      GRAVE: oracle.dbtools.raptor.utils.AnsiColorListPrinter.setScriptContext(AnsiColorListPrinter.java:34)
      java.lang.NullPointerException
              at oracle.dbtools.raptor.utils.AnsiColorListPrinter.setScriptContext(AnsiColorListPrinter.java:34)
              at oracle.dbtools.raptor.format.ANSIConsoleFormatter.setContext(ANSIConsoleFormatter.java:47)
              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:126)
              at oracle.dbtools.db.ResultSetFormatter.formatResults(ResultSetFormatter.java:71)
              at oracle.dbtools.raptor.newscriptrunner.SQL.processResultSet(SQL.java:798)
              at oracle.dbtools.raptor.newscriptrunner.SQL.executeQuery(SQL.java:709)
              at oracle.dbtools.raptor.newscriptrunner.SQL.run(SQL.java:83)
              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.runSQL(ScriptRunner.java:404)
              at oracle.dbtools.raptor.newscriptrunner.ScriptRunner.run(ScriptRunner.java:230)
              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:344)
              at oracle.dbtools.raptor.newscriptrunner.ScriptExecutor.run(ScriptExecutor.java:227)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.process(SqlCli.java:403)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.processLine(SqlCli.java:414)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.startSQLPlus(SqlCli.java:1248)
              at oracle.dbtools.raptor.scriptrunner.cmdline.SqlCli.main(SqlCli.java:490)
             
      SQL> select * from data;
      aucune ligne sÚlectionnÚe
      
      SQL> show all
      _prelim OFF
      appinfo est OFF et est dÚfini sur "SQLcl"
      arraysize 15
      autocommit OFF
      autoprint OFF
      autotrace OFF
      BTitle OFF
      SQL*Plus mode: OFF
      Mode Effacer l'Úcran : top
      oracle.net.tns_admin=null
      javax.net.ssl.trustStore=null
      javax.net.ssl.trustStorePassword=null
      javax.net.ssl.keyStore=null
      javax.net.ssl.keyStorePassword=null
      oracle.net.ssl_server_dn_match=null
      oracle.net.ssl_version=null
      colinvisible OFF
      colsep " "
      concat "." (hex 2e)
      copycommit 0
      define "&" (hex 26)
      show desc is obsolete.
      echo OFF
      editfile "afiedt.buf"
      
      embedded OFF
      Encodage : windows-1252
      errorlogging is OFF
      escape OFF
      exitcommit ON
      FEEDBACK ON pour au moins 6 lignes
      en-tÛte ON
      headsep "|" (hex 7c)
      HISTORY
              enabled
              blacklist: show,history,connect,set
              Do not show failed statements
      linesize 80
      long 80
      longchunksize 80
      newpage 1
      NULL /*notset*/
      numformat ""
      numwidth 10
      pagesize 14
      PAUSE est OFF
      version 1102000400
      scan ON
      secureliterals DEFAULT
      serveroutput OFF
      SHOWMODE OFF
      space " "
      spool OFF
      sqlcode 0
      sqlprompt "SQL>  "
      suffix "sql"
      termout ON
      heure OFF
      timing OFF
      TNS Lookup locations
      --------------------
      1.  USER Home dir
      Location used:
      -------------
      Available TNS Entries
      ---------------------
      trimout ON
      trimspool OFF
      ttitle OFF and is the first few characters of the next SELECT statementUSER est "FP13258_UR1A_OPR"
      verify ON
      Version d'Oracle SQLDeveloper Command-Line (SQLcl) : 19.1.0.0
      No Wallet location defined
      
      retour Ó la ligne : les lignes vont faire l'objet d'un retour Ó la ligne