Can I run stored procedures from change log?

General Discussion
1

Hi,

Is there any way to call (execute) a store procedure from liquibase?

Regards,
Pablo.

2

You’ll have to use the tag, but you should be able to use “call proc_name” or “exec proc_name” to call your procedure.

Nathan

3

It Works!!!

Thanks Nathan…

4

Hi,

I tried exec procedure_name but I get “Migration Failed: Error executing SQL exec procedure_name” when I run.Could you let me know how you solved this?

5

Your database may use a different syntax, such as “call procedure_name” or just procedure_name().  Whatever works in your SQL browser should work from the tag.

What database are you using?

Nathan

6

I am using Oracle exec procedure_name and procedure_name() dint work.

7

Does call procedure_name work?

Nathan

8

call procedure_name(); works

Thanks!