Hi, I am relatively new to liquibase.
I started testing liquibase community edition (4.8.0) if all the supported objects can be actually generated using an Oracle 19 DB.
I got stuck with procedures and would like to know if I am doing something wrong or if actually something is wrong.
So my failing test case is that I created a table and a procedure which adds data to this table when called.
When I generate the changelog the procedure is always missing and I am out of ideas on what to try and where to look for examples or help.
liquibase 4.8.0 portable on Win10
Oracle Virtual Lab Oracle 19 database in VirtualBox (Oracle Database 19c Enterprise Edition Release 126.96.36.199.0 - Production Version 188.8.131.52.0)
Somewhere I read that someone solved a similar issue by using a trial-pro-key.
Here also similar info is given: 4783
But in the official documentation ‘procedure’ is not marked as PRO or listed among pro features but community features. change-types
CREATE TABLE T_CICD_USER2 (
USER_ID VARCHAR2(20 BYTE) NOT NULL,
USER_NAME VARCHAR2(20 BYTE),
CHNG_DATE TIMESTAMP(6) DEFAULT CURRENT_TIMESTAMP NOT NULL,
CHNG_ID VARCHAR2(20 BYTE) NOT NULL);
create or replace PROCEDURE P_FILL_T_CICD_USER2 AS
insert into t_cicd_user2 (chng_date, chng_id, user_name,user_id) values
Hi daryldoak, thanks for your hint! I wonder how I was able to overlook it before…
Anyways, its still totally confusing to me to get a clear picture on the functional difference between community and pro edition.
The documentation also just says that special folders will be created using PRO but its not that clear that general support of the changetypes is also included.
In the documentation also ‘view’ is listed under PRO features for generateChangeLog. But when I checked again just now it actually seems to be included in community edition. Can you help me to understand where I am wrong?
I also noticed when using PRO key that no folder for views is created in objects folder structure.
citation from docu:
Additional functionality with Liquibase Pro
While Liquibase Community stores all changesets in a changelog, Liquibase Pro creates a directory called Objects and places the directory at the same level as your changelog. The Objects directory contains a subdirectory for each of the following stored logic types:
hi, just referenced my older post before deleting it because I can’t edit it. I forgot to change one internal user name and seems that I can’t edit the post anymore. So here is the cleaned reference instead.