loadUpdateData sometimes needs / and sometimes not

Description

See http://forum.liquibase.org/topic/loadupdatedata-problem

I've seen the post
http://forum.liquibase.org/topic/problem-with-sql-scripts-generated-for-loadupdatedata

Now, when I run loadUpdateData, I get
Copy code
Copy code
SEVERE 17/05/12 1:26 PM:liquibase: Change Set /local/changelog.xml::insertdata-1::Maven failed. Error: Error executing SQL DECLARE
v_reccount NUMBER := 0;
BEGIN
SELECT COUNT INTO v_reccount FROM unit_survey.locations WHERE location_cd = '1';
IF v_reccount = 0 THEN
INSERT INTO unit_survey.locations (active_fg, create_date, create_user, display_fg, location_cd, location_nm, modify_date, modify_user) VALUES ('Y', NULL, 'UNIT_SURVEY', 'Y', '1', 'Bentley Campus', NULL, 'INT_USER');
ELSIF v_reccount = 1 THEN
UPDATE unit_survey.locations SET active_fg = 'Y', create_date = NULL, create_user = 'UNIT_SURVEY', display_fg = 'Y', location_nm = 'Bentley Campus', modify_date = NULL, modify_user = 'INT_USER' WHERE location_cd = '1';
END IF;
END;
/: ORA-06550: line 11, column 1:
PLS-00103: Encountered the symbol "/" The symbol "/" was ignored.
I'm using Oracle thin driver ojdbc6-11.2.0.3 and running the task with Maven.

I guess you should add an attribute on loadUpdateData to generate the "/" or not...

Environment

None

Activity

Show:
DevFactory CodeRead [MB]
November 12, 2012, 4:31 PM

Oracle needs the "/" when SQL file is generated but not when commands are executed directly to JDBC

DevFactory CodeRead [MB]
November 12, 2012, 4:38 PM
Juraj Misur
March 25, 2013, 9:32 AM
Edited

Is above mentioned fix available in some snapshot build? What is the ETA for 2.0.6?

Reporter

Nathan Voxland

Fix versions

Priority

Major
Configure