It looks like maybe this is a snipit from your DB Managment system, if not then you should avoid SQL scripts, as SQL scripting isn't in the JDBC spec., even if some drivers tolerate them.
If this isn't already a stored procedure then it probably should be. There are multiple ways that a SP can be run from Ignition.
However, you should know that you can use system.db.beginNamedQueryTransaction() to create and run named queries in a transaction, you really don't need return the status of the transaction from the query. (If that is all the stored procedure is intended to do). If you do this, you should not use a transaction inside of the query or stored procedure.
Also, a named query by default returns the number of effected rows, which, would indicate if the transaction was committed or rolled back, as a rolled back transaction by definition can not effect any rows.
More information on when different tools for running queries in ignition should be used can be found here: