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.