Stack Overflow
Stack Overflow

Questions tagged [sqlcl]

sqlcl is a command line interface for Oracle databases.

sqlcl is a command line inteface for Oracle databases. It is similar to SQL*Plus but contains additional features such as in-line editing and auto-completion.

Questions with the tag should probably also have the tag.

81 questions
0
votes
1 answer

APEX export with SQLcl results in ORA-06502: PL/SQL: numeric or value error

SQLcl: Release 22.3 Production auf Fr. Nov. 04 17:19:43 2022 SQL> apex export -applicationid 1681 Exporting Application 1681 java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error ORA-06512: in "APEX_220100.WWV_FLOW_EXPORT_API", row…
jzzh
  • 23
  • 7
0
votes
0 answers

SQLcl 22.1.1 requires a future Java version?

I'm a little bit stuck here. It seems the current SQLcl (22.1.1.131.0820 - May 11, 2022) requires a future Java version? C:\Oracle SQLcl\bin>java -version java version "1.8.0_333" Java(TM) SE Runtime Environment (build 1.8.0_333-b02) Java…
Markus L
  • 932
  • 2
  • 20
  • 38
0
votes
0 answers

SQLcl Nashorn js missing on upgrade?

Recently upgraded to SQL Developer 21.4.3.063.0100 on Java 1.8.0_311 from 18.1.0.095.1630 on Java 1.8.0_152 And now all scripts running through the sqlcl component fail on startup Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF-8 SQLcl: Release…
Skytunnel
  • 1,063
  • 2
  • 10
  • 21
0
votes
1 answer

Substitution variable && not working in SQLcl

The "new" tool Oracle SQLcl is not interpreting "&&" correctly. Is there an option to correct this behavior? Copyright (c) 1982, 2022, Oracle. All rights reserved. Last Successful login time: Tue May 10 2022 18:17:49 -04:00 Connected to: Oracle…
MarcioElizeu
  • 85
  • 6
0
votes
1 answer

sqlcl 20.3 apex execution vs sqlplus

I have several environments where we have implemented sqlcl and apex versioning. Oracle database 19c - SqlCL version 20.3 The only difference versus other environment is the OCI has a PDB defined. When trying to implement changes on OCI environment…
Agustin Conejos
  • 1
  • 2
0
votes
2 answers

Exporting all oracle apex applications using sqlcl

I would like to run a sqlcl command that exports every application and not just one. Apex export # works just fine but if I try apex export -instance which is stated to "Export all applications", it says that Application export requires an…
J.H
  • 1
  • 1
  • 2
0
votes
1 answer

how to upload a regular file (eg cwallet.sso ) to data_pump_dir in oracle db?

Currently I am doing this to upload cwallet.sso (ie a "normal" file, not an export, etc.) to an Oracle Autonomous Database... BEGIN DBMS_CLOUD.GET_OBJECT( object_uri =>…
Paul Parkinson
  • 43
  • 5
0
votes
1 answer

I have an error when I genobject ORDS using Oracle SQLcl

I have following error when I want to export ORDS object using: SQL> lb genobject -type ORDS; ORA-20850: Parameter p_module_id must not be null. ORA-06512: at "ORDS_METADATA.ORDS_EXPORT", line 235 ORA-06512: at "ORDS_METADATA.ORDS_EXPORT", line…
Salvador Arreola Rojas
  • 45
  • 5
0
votes
1 answer

How to run sqlcl outside of SQL Developer directory

I have installed the Oracle client WINDOWS.X64_213000_client.zip and I want to use the bundled sql.exe to run SQL scripts in my project directory. The sql.exe is located in the following directory which I have added to my Path env…
crowne
  • 8,456
  • 3
  • 35
  • 50
0
votes
1 answer

SQLcl fails to run scripts even with Oracle JDK 8 installed

I have Oracle JDK 8 installed and SQLcl of version 21.3. I want to run simple js script but SQLcl cannot find js engine. I run SQLcl from PowerShell under Windows 10: PS C:\run_scripts_sqlcl> sql /nolog Picked up JAVA_TOOL_OPTIONS:…
Roman
  • 473
  • 5
  • 22
0
votes
1 answer

SQLcl is unable to find js engine to process js scripts

When I want to run script written in js I get a message about missing js engine in my classpath: SQL> script 2 ctx.write('hi'); 3* / js language engine not found Please add js language engine to the classpath SQL> Here's my Java params: PS…
Roman
  • 473
  • 5
  • 22
0
votes
1 answer

how to parse raw result of sqlci query with TelnetClient in java

how can i parse raw sqlci query result executed with TelnetClient in java? I was trying something like this: String responeExample = "CLI_IDC CLI_VRT CLI_IND_PER_EMP CLI_TIP CLI_CIC CLI_COD_EST\n" + …
fneira
  • 291
  • 1
  • 8
0
votes
1 answer

Make liquibase output be spooled to the current spool file when running using sqlcl

Assume we have the following set of scripts: test.sql create or replace view asdas as select 1 val from dual / controller.xml
Roman
  • 473
  • 5
  • 22
0
votes
0 answers

Running sql script in Jenkins using SQLcl

I am newbie in Jenkins and I would like to use Oracle SQLcl to run sql query before starting the job. Earlier I planned to use SQLPlus Script Runner but it requires additional software(Oracle SQL*Plus) and I cannot install it on the machine. Oracle…
larry
  • 1
  • 1
  • 2
0
votes
1 answer

How can I most simply automate an Oracle query in windows?

I need to run the same damn Oracle query daily (and export the output, which I can do from the sql file itself). I'd like to automate using Windows Task Scheduler but it only opens the script, and it doesn't run it. Is this feasible or is there an…
Blake Shurtz
  • 321
  • 3
  • 13
1 2 3
4
5 6