Script working fine from sqlplus (oracle) not in liquibase

General Discussion
1

HI ,

Script working fine from sqlplus (oracle ) failed from liquibase .

Reason: liquibase.exception.DatabaseException: ORA-00900: invalid SQL statement
[Failed SQL: (900) procedure ins_document_notes(
p_**** in .%type,
p_***** in *****.******c%type := null,
)]
For more information, please use the --logLevel flag

2

Can you provide your changeset so we can review it?

3

–liquibase formatted sql
–changeSet Ramesh:*****.sql endDelimiter=/

Regards

4

please help me to resolve this .

Regards ,
ramesh

5

Hi @kalyandrug

I’m not a pro in sqlplus(oracle) so please bear with my silly questions if I come across any.

From this doc, I see it’s mentioned :

If you use the Liquibase Pro feature runWith=sqlPlus , follow these rules with formatted SQL changelog s :

  • Do not set the endDelimiter property on the changeset. This affects SQLPlus.
  • Ensure that the SplitStatements attribute is set to true , which is the default value.

In the changeset you have shared in comments, I’m unclear as to what exactly have you used.

Could you please help understand thi line?

Thanks,
Rakhi Agrawal