Problem converting raiserror (T-SQL to PL/SQL)
654626Aug 19 2008 — edited Aug 29 2008Helo,
I'm using SQL Developer 1.5.1 (build 5440), and i'm trying to migrate a database from SQL Server 2000 to Oracle 11g (Windows version).
If I have a stored procedure like this:
create procedure sp_foo4
as
begin
declare @Problem varchar(255)
set @Problem = 'error'
raiserror(@Problem, 16, -1)
end
It's translation will be:
CREATE OR REPLACE PROCEDURE sp_foo4
AS
v_Problem VARCHAR2(255);
BEGIN
v_Problem := 'error';
raise_application_error( -20002, || ':' ||v_Problem );
END;
so, there's an extra || in the code.