Unable to create stored procedure in SQL server

Liquibase Development
1

Hi Folks,

Good Day!

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>
2

For troubleshooting, please run liquibase updateSQL command, which will give output on stdOut on what is being run.