Rule Definition
Not managing errors can lead to data corruption and erroneous behaviour.

Remediation
Add error management into the stored procedures and functions using an Insert, Update, Delete, Select or Create Table.

Violation Code Sample

update mytable set col1 = 123
where col2 = 456

Fixed Code Sample

Declare @OpenedTran      bit
Declare @Error           int

/*See if a transaction is already opened and possibly open a new one*/
If @@trancount>0
     Select @OpenedTran = 1
Else
  Begin
     Select @OpenedTran = 0
     Begin Tran
  End

update mytable set col1 = 123
where col2 = 456

Select @Error = @@error
GTRAN:
/*Close or rollback the transaction if it has been opened in this procedure*/
If @OpenedTran = 0
  Begin
     If @Error = 0   /* no error occurs*/
          Commit Tran
     Else
          Rollback Tran
  End
/*If this procedure is not called from another one, Raise an error*/
If @@nestlevel = 1
  Begin
     If @Error !=0
          Raiserror xxx

  End
/*return the error value*/
Return @Error

Oracle : https://docs.oracle.com/cd/E11882_01/timesten.112/e21639/exceptions.htm#TTPLS194 SQL Server : https://docs.microsoft.com/fr-fr/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver15, https://docs.microsoft.com/fr-fr/sql/t-sql/functions/error-transact-sql?view=sql-server-ver15