Applies to:
- Liquibase Enterprise (Datical DB)
Conditions:
- Using a Java-style multiline comment
- The target database is Oracle
- Using SQLPlus
- Any version of Liquibase Enterprise
Issue Summary:
When attempting to package a script that contains a Java-style multiline comment, an error showing the comment as an unknown command occurs.
Error Message:
Query: <comment>>> Has an error: SP2-0734: unknown command beginning "<comment>" - rest of line ignored.
Root Cause:
There is a known issue that is reproducible outside of Liquibase where SQLPlus will fail with the above error if the Java-style multiline comment doesn't have a space after the first asterisk.
For example:
The following will fail with the SP2-0734 error in SQLPlus
/*COMMENT
COMMENT
*/
Resolution:
This can be resolved in two separate ways.
- Add a space after the first asterisk
-
/* COMMENT
COMMENT
*/
-
- Move the comment to a new line
-
/*
COMMENT
COMMENT
*/
-
Comments
0 comments
Article is closed for comments.