[BUG]: Converted store procedure from TSQL does not have proper semicolon or variable declaration as well as incorrect exception code

[roshniagar]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

Converter bug

Current Behavior

The code has invalid variable declaration, missing end of statement semicolon and incorrect handling of SQL exceptions.
UCP.sql

UCP_output.sql

Expected Behavior

No response

Steps To Reproduce

No response

Relevant log output or Exception details

Logs Confirmation

• I ran the command line with --debug
• I have attached the lsp-server.log under USER_HOME/.databricks/labs/remorph-transpilers/<converter_name>/lib/lsp-server.log

Sample Query

Operating System

macOS

Version

latest via Databricks CLI