# An unexpected syntax result with updateSQL for dbms:oracle

**URL:** <https://forum.liquibase.org/t/an-unexpected-syntax-result-with-updatesql-for-dbms-oracle/8291>\
**Category:** General Discussion\
**Created:** [May 31, 2023, 7:04pm UTC](https://forum.liquibase.org/t/an-unexpected-syntax-result-with-updatesql-for-dbms-oracle/8291 "2023-05-31T19:04:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlpurcalla](https://avatars.discourse-cdn.com/v4/letter/j/97f17d/32.png) [@jlpurcalla](https://forum.liquibase.org/u/jlpurcalla)\
**Post date:** [May 31, 2023, 7:04pm UTC](https://forum.liquibase.org/t/an-unexpected-syntax-result-with-updatesql-for-dbms-oracle/8291/1 "2023-05-31T19:04:44Z")

</div>

with liquibase 4.21.1 and former i got an unexpected migrate.sql from updateSQL command

my changeset is like this…

```auto
--changeset pep:1 dbms:oracle context:"test" runOnChange:true failOnError:false endDelimiter:/ 

CREATE OR REPLACE PROCEDURE myproc AS
BEGIN
	declare
	BEGIN
               select 'dosomething' from dual;
	END;
END;
/

--rollback empty

```

and I get a invalid END;\ for Oracle SQLDeveloper

```auto
-- Changeset db/model/pep.sql::1::pep
CREATE OR REPLACE PROCEDURE myproc AS
BEGIN
	declare
	BEGIN
               select 'dosomething' from dual;
	END;
END;/

```

Some idea about this?  
Thanks in advance

---

<div class="post-metadata">

**Author:** ![PJatLiquibase](https://avatars.discourse-cdn.com/v4/letter/p/d26b3c/32.png) [@PJatLiquibase](https://forum.liquibase.org/u/PJatLiquibase)\
**Post date:** [June 1, 2023, 4:59pm UTC](https://forum.liquibase.org/t/an-unexpected-syntax-result-with-updatesql-for-dbms-oracle/8291/2 "2023-06-01T16:59:03Z")

</div>

Hi @jlpurcalla,

If I am reading correctly, the endDelimiter needs to be on a line by itself, i.e. the `\` needs to be on the next line. Correct?

If you remove the `endDelimiter:/ ` setting, does it work correctly? Or it may work better to change the setting to `endDelimiter:\n/`.

`-PJ`

---

<div class="post-metadata">

**Author:** ![jlpurcalla](https://avatars.discourse-cdn.com/v4/letter/j/97f17d/32.png) [@jlpurcalla](https://forum.liquibase.org/u/jlpurcalla)\
**Post date:** [June 1, 2023, 6:27pm UTC](https://forum.liquibase.org/t/an-unexpected-syntax-result-with-updatesql-for-dbms-oracle/8291/3 "2023-06-01T18:27:18Z")

</div>

Hi @PJatLiquibase and thanks for u asnwer!!

Using a endDelimiter:\n/ works fine for a updateSQL and for a simple update as well !!

Is a good solution even when a / is included inside text, i.e in a division .

Thanks!