This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Medium
Description
PL/SQL declarations in WITH statements are not supported.
Example Code
Input Code:
WITH FUNCTION get_domain ( url VARCHAR2 ) RETURN VARCHAR2 IS pos BINARY_INTEGER;
len BINARY_INTEGER;
BEGIN
pos := INSTR(url, 'www.');
len := INSTR(SUBSTR(url, pos + 4), '.') - 1;
END; SELECT aValue from aTable;
Output Code:
WITH
-- ** MSC-ERROR - MSCEWI3033 - PLDECLARATION IN WITH NOT SUPPORTED **
-- FUNCTION get_domain ( url VARCHAR ) RETURN VARCHAR IS pos BINARY_INTEGER;
--len BINARY_INTEGER;
--BEGIN
--pos := POSITION( 'www.', url);
--len := POSITION( '.', SUBSTR(url, pos + 4)) - 1;
--END;
SELECT aValue from MYDB.PUBLIC.aTable;