Problems Migrating Sybase Stored Procedures Using Sqldevloper (Doc ID 885646.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle SQL Developer - Version 1.5.4 to 2.1.2
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Problem converting Sybase stored procedures to Oracle stored procedures.
For example, the Sybase code -

IF @flg IS NULL
BEGIN
INSERT #sp_output(msg)
SELECT "Cannot find batch sheet for "+@empl_user_id+" (empl_id
"+convert(varchar(10),@empl_id)+")"+
" and date "+convert(varchar(10),@dte,101)
RETURN -1
END

Gives error -

Cannot convert - null


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms