SQL command not properly ended

General Discussion
1

Hi Team,

While running update command getting below error. Can you please assist.

ERROR:
Reason: liquibase.exception.DatabaseException: ORA-00933: SQL command not properly ended

FILE:

–liquibase formatted sql
–changeset includeAll:raw runOnChange:true endDelimiter:/

CREATE OR REPLACE VIEW EV_VW_V_TEMP AS
SELECT a.N_AGT_NO, V_AGT_CODE, BPG_AGENCY.BFN_GET_AGT_NAME_BY_AGTNO(a.N_AGT_NO) V_AGT_NAME
FROM EV_AM_PROMO_PROD_ACTUAL_TEMP a, AMMM_AGT_MST b
WHERE a.N_AGT_NO = b.N_AGT_NO
GROUP BY a.N_AGT_NO, V_AGT_CODE;
/

2

You indicated that the end-delimiter for this changeset is /, so you need to remove the semi-colon in the code. There can only be 1 end-delimiter used in a changeset.

That being saidf, since this is not PL/SQL, there really is no need to set / as the end-delimiter. You can just remove that parm, and the / in the code.