Create view always gets an error: ORA-00933: SQL command not properly ended
Description
Environment
Linux
Activity
Show:

Jim Zucker June 7, 2018 at 4:36 PM
we got it to work by removing the semi-colon from the end of the view definition.

Jim Zucker June 5, 2018 at 1:27 PM
To confirm/clarify a couple of points:
1. The same error occurs if we use a schema, we removed it in the test case to make it simpler to test
ORA-00933: SQL command not properly ended Reason: liquibase.exception.DatabaseException: ORA-00933: SQL command not properly ended [Failed SQL: CREATE OR REPLACE VIEW ARO.USER_V AS select table_name FROM user_tables ORDER BY table_name;]
2. The sql produced by liquibase does execute correctly if we do updateSQL
*We have a simple create view test case on Liquibase 3.6.1 command line:*
We are trying to understand how to solve the error: ORA-00933: SQL command not properly ended
We have tried
1. <sql>
2. <createview>
3. Note the SQL generated by the <createview> executes correctly if we take it and run it manually.
Below is a simple test case.
Here is the changelog:
*Command*
{{time ./liquibase --changeLogFile=../changelog/test.xml --url=jdbc:oracle:thin:@//localhost:1521/ORCL --username "sys as sysdba" --password oracle --logLevel debug update
We always get this exception: (FYI we also tried as <sql> same result)
The sql test case gets the same error.