[SPCONV-ERR(<NN>)]:(WITH <STRING>) Ignored. Manual Conversion May be Required

RAISERROR .. WITH options have no direct equivalent in Oracle. WITH LOG, WITH NOWAIT, and WITH SETERROR are ignored.

The following example illustrates how the T-SQL to PL/SQL parser in the Migration Workbench could produce this error:

/* a comment*/
CREATE PROC myerror
AS
BEGIN
raiserror(50324,12,5) WITH LOG
END

The following code is the PL/SQL code produced by the parser:

CREATE OR REPLACE PROCEDURE myerror
AS
StoO_selcnt INTEGER;
StoO_error  INTEGER;
StoO_rowcnt INTEGER;
StoO_errmsg VARCHAR2(255);
StoO_sqlstatus INTEGER;
/* a comment*/

BEGIN
 raise_application_error(-20999, 'id 50324');
 /*[SPCONV-ERR(5)]:('Raiserror ( num') MANUAL CONVERSION MIGHT BE REQUIRED
num gives id in MS SQL Server SYSCOMMENTS table*/

 /*[SPCONV-ERR(5)]:(WITH LOG)ignored, Manual conversion may be required*/

END;

There is no direct equivalent of WITH LOG in Oracle.