Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 392 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
SQLcl 22.1 throws error during Liquibase update
Hello all,
the latest version of SQLcl (22.1) throws error "registerOutParameter not implemented" when calling command "lb update" and cannot process the changelogfile further. In addition, it displays messages about insufficient permissions even though all necessary objects have been created inside the schema.
[email protected]_server:/home/oracle$ [email protected]_server:/home/oracle$ java -version java version "11.0.13" 2021-10-19 LTS Java(TM) SE Runtime Environment 18.9 (build 11.0.13+10-LTS-370) Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.13+10-LTS-370, mixed mode) [email protected]_server:/home/oracle$ ./sqlcl/bin/sql /nolog SQLcl: Release 22.1 Production on Fri Apr 15 22:10:29 2022 Copyright (c) 1982, 2022, Oracle. All rights reserved. SQL> version Oracle SQLDeveloper Command-Line (SQLcl) version: 22.1.0.0 build: 22.1.0.90.1611 SQL> SQL> conn test_user/[email protected]_server/TESTDATABASE Connected. login.sql found in the CWD. DB access is restricted for login.sql. Adjust the SQLPATH to include the path to enable full functionality. SQL> SQL> select object_name,object_type,status from USER_OBJECTS where object_name like 'DATABASE%'; 0 rows selected. SQL> SQL> lb update -changelog _install_packages.xml --Starting Liquibase at 22:11:01 (version 4.7.1 #0 built at 2022-01-25 22:12+0000) registerOutParameter not implemented registerOutParameter not implemented Unable to create a needed object please review error and issue needed privileges. Ensure user has create table and create procedure permissions. Unable to create a needed object please review error and issue needed privileges. Ensure user has create table and create procedure permissions. SQL> SQL> select object_name,object_type,status from USER_OBJECTS where object_name like 'DATABASE%'; OBJECT_NAME OBJECT_TYPE STATUS ______________________________ ______________ _________ DATABASECHANGELOG_EXPORT_UK INDEX VALID DATABASECHANGELOG_EXPORT TABLE VALID DATABASECHANGELOGLOCK TABLE VALID DATABASECHANGELOG TABLE VALID 4 rows selected. SQL>
Is anyone else experiencing the same problem?
Thanks.