SQLcl

Discussion List

• 
  Spool command broken in SQLcl 20.3 with 19.9 client

  user832387 75 views 4 comments 0 points Most recent by user832387 January 20
• 
  runOracleScript with file and relative path

  Question Alex Nuijten 15 views 0 comments 0 points Started by Alex Nuijten January 13
• 
  JAVA_HOME on Windows

  Solution Accepted David Madden 92 views 6 comments 1 point Most recent by user8632123 January 13
• 
  Slow startup time

  Responded But No Solution zef 21 views 1 comment 0 points Most recent by user9540031 December 2020
• 
  Unable to connect to 19c database using sqlcl 20.3 - Invalid argument

  Question User_8G51C 21 views 0 comments 0 points Started by User_8G51C December 2020
• 
  Connect and run a script

  Responded But No Solution user13117585 37 views 2 comments 0 points Most recent by Gaz in Oz December 2020
• 
  sqlcl Ctrl+C handler

  Responded But No Solution user11973317 269 views 3 comments 0 points Most recent by Billy Verreynne November 2020
• 
  Bug? sqlcl 20.2 doesn't honor cd for apex export

  Question peter_raganitsch 66 views 1 comment 1 point Most recent by jflack November 2020
• 
  JAVA_TOOL_OPTIONS incorrectly picked up

  Solution Accepted user8632123 74 views 2 comments 1 point Most recent by user8632123 November 2020
• 
  SQLcl whitespace in output fixed in 20.3!

  EJ-Egyed 26 views 0 comments 1 point Started by EJ-Egyed November 2020
• 
  sqlcl COPY/REPLACE implementation does not drop existing table

  Question B.Delmée 26 views 0 comments 0 points Started by B.Delmée October 2020
• 
  Setting delimiter for LOAD to semicolon. Glitch?

  Question Erik van Roon 24 views 0 comments 1 point Started by Erik van Roon October 2020
• 
  How to suppress schema in liquibase genobject/genschema output?

  Responded But No Solution 3020583 49 views 4 comments 0 points Most recent by thatJeffSmith-Oracle October 2020
• 
  SQLcl 20.2 export apex 19.1

  Question crych 46 views 0 comments 0 points Started by crych September 2020
• 
  Info with more details

  Responded But No Solution aoflima44 38 views 2 comments 0 points Most recent by aoflima44 September 2020
• 
  SQLcl 20.2 places two blank lines at top of CSV file

  Responded But No Solution Jayson 57 views 1 comment 1 point Most recent by Erik van Roon September 2020
• 
  Serveroutput bug got worse in 20.2

  Responded But No Solution Erik van Roon 202 views 6 comments 5 points Most recent by Tim St. H. September 2020
• 
  Not able to run SQLcl in windows CMD even after setting path in environment variables.

  Solution Accepted User_ZUUOD 144 views 8 comments 0 points Most recent by User_ZUUOD September 2020
• 
  Describe system dynamic views v$ failed

  danutz_68 99 views 4 comments 1 point Most recent by User273940_Dagmar August 2020
• 
  SQLCL and Liquibase installing APEX applications

  Solution Accepted Alex Nuijten 204 views 1 comment 0 points Most recent by skutz-Oracle August 2020
• 
  Random Ansi symbols in output text file

  Responded But No Solution User_QSVY3 45 views 1 comment 0 points Most recent by Gaz in Oz August 2020
• 
  is _RC trustworthy?

  Responded But No Solution berx 57 views 3 comments 1 point Most recent by Gaz in Oz August 2020
• 
  NLS_LANG prevents sqlci from reading scripts

  Responded But No Solution user8632123 69 views 3 comments 0 points Most recent by Gaz in Oz August 2020
• 
  SQLcl SQLPROMPT _USER value in lowercase

  Solution Accepted Mike301 91 views 3 comments 2 points Most recent by Mike301 August 2020
• 
  Set ARRAYSIZE for BRIDGE command?

  Question berx 42 views 0 comments 0 points Started by berx July 2020
• 
  Can I use Secure External Password Store in BRIDGE command?

  Solution Accepted berx 65 views 1 comment 0 points Most recent by berx July 2020
• 
  Sqlcl 20.2 Liquibase package replace ORA-00955

  Question Doug Phelps 40 views 0 comments 0 points Started by Doug Phelps July 2020
• 
  SQLcl

  Responded But No Solution 4201252 38 views 1 comment 0 points Most recent by Glen Conway July 2020
• 
  ORA-01882 in SQLcl connection

  Question peter.ocelka 49 views 0 comments 0 points Started by peter.ocelka July 2020
• 
  What is "Optimized/Unoptimized" in serveroutput?

  Solution Accepted Erik van Roon 86 views 2 comments 1 point Most recent by Erik van Roon July 2020
• 
  sqlcl start and spool commands not working

  Responded But No Solution zsysdba 84 views 2 comments 0 points Most recent by zsysdba July 2020
• 
  This still does not appear to work in Windows...

  Responded But No Solution user12248089 128 views 8 comments 0 points Most recent by user832387 July 2020
• 
  Liquidbase - update state based on git-versioned files

  Responded But No Solution MauroPagano 104 views 2 comments 1 point Most recent by MauroPagano July 2020
• 
  SQLCL Liquibase ORA-12899 error on genschema

  Responded But No Solution Doug Phelps 146 views 3 comments 0 points Most recent by Doug Phelps July 2020
• 
  SQLcl 20 - java.lang.RuntimeException: Unable to parse url "..." at oracle.net.resolver.EZConnectRes

  berx 136 views 0 comments 0 points Started by berx July 2020
• 
  Bug in SQLcl - ctrl-c only aborting top level script unlike SQL*Plus

  2990075 79 views 1 comment 0 points Most recent by thatJeffSmith-Oracle June 2020
• 
  Reporting a BUG in handling plsql in sql

  Responded But No Solution Erik van Roon 94 views 3 comments 2 points Most recent by thatJeffSmith-Oracle June 2020
• 
  Local connection library error

  Responded But No Solution 4218299 350 views 6 comments 0 points Most recent by bddda057-7788-423a-9ec8-0ed2a5d6a3c0 June 2020
• 
  Not able to launch SQLCL with SQL command on CMD prompt

  Responded But No Solution User_ZUUOD 98 views 1 comment 0 points Most recent by Gaz in Oz May 2020
• 
  SQLcl 19.4 - "java.lang.UnsupportedClassVersionError Bad Version number in .class file"

  Solution Accepted Mike301 90 views 4 comments 0 points Most recent by Mike301 May 2020
• 
  sqlcl 18.1.1 connect / as sysdba with 11.2.0.4 DB

  Responded But No Solution dougk 4.4K views 8 comments 2 points Most recent by Mike301 May 2020
• 
  I'm used to stopping the output stream of a Windows command-line program by typing ctrl-c. When I do

  Responded But No Solution RedWhiteNBlue 73 views 1 comment 0 points Most recent by Glen Conway April 2020
• 
  "However, you can force a ‘thick’ connection via your Oracle Client by using the –oci flag on your c

  Responded But No Solution RedWhiteNBlue 530 views 8 comments 1 point Most recent by RedWhiteNBlue April 2020
• 
  apex_export.get_application - truncated output using SQLcl v. 19.4

  Question Franco Soldera 77 views 0 comments 0 points Started by Franco Soldera April 2020
• 
  Variable is a NUMBER but APEX EXPORT doesn't accept it

  Solution Accepted Franco Soldera 127 views 3 comments 1 point Most recent by Gaz in Oz April 2020
• 
  Connect sequentially to multiple schemas

  Responded But No Solution user13117585 56 views 1 comment 0 points Most recent by Gaz in Oz April 2020
• 
  Show Error behavior

  Question Erik van Roon 36 views 0 comments 0 points Started by Erik van Roon April 2020
• 
  Incompatibility: sqlcl does not allow trailing "/" in connect identifier (while sqlplus does)

  User_E4DJL 37 views 0 comments 0 points Started by User_E4DJL April 2020
• 
  json.value output in sqlcl vs. sqlplus

  Question Paavo 20 views 0 comments 0 points Started by Paavo April 2020
• 
  Set SQLcl Path on linux

  Responded But No Solution Eric.Sacramento 134 views 6 comments 1 point Most recent by Eric.Sacramento March 2020