Need your suggestion or advice on the below issue. I am unable to create a stored procedure in SQL server. We are trying to execute the below changeset . So when I update through liquibase command , the DATABASECHANGELOG is successfully capturing but the Stored procedure is not created. Where as If I create manually in database the stored procedure is successfully created. Could you please check and give your suggestions. Thanks in advance.
<changeSet author="bharatbolla" id="createProcedure-GETRoleAgency" > <createProcedure dbms="h2, !oracle, mysql" encoding="utf8" procedureName="STATECODE" schemaName="public" relativeToChangelogFile="true">CREATE PROCEDURE [dbo].[IN_GET_STATES] @role nvarchar(50) AS BEGIN SET NOCOUNT ON; SELECT STAT_CODE FROM dbo.TBL_STATECODE_MAPPING WHERE ROLE_NAME=@role END;</createProcedure> </changeSet>