Compiling a Procedure Containing "OMWB_EMULATION"."UTILITIES"."YEAR" fails with Error ORA-00904 (Doc ID 444553.1)

Last updated on AUGUST 29, 2010

Applies to:

Oracle Migration Workbench - Version: 10.2 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.

Symptoms

Having an Informix procedure like:
CREATE PROCEDURE emp_year() RETURNING VARCHAR(64);
DEFINE s VARCHAR(64);

SELECT year(hire_date) into s from emp where emp_id='E63535';
RETURN s;

END PROCEDURE;

Using OMWB to migrate it to Oracle creates a procedure like:
CREATE OR REPLACE PROCEDURE emp_year AS

s VARCHAR2(64);
ItoO_selcnt NUMBER;
ItoO_rowcnt NUMBER;

BEGIN

SELECT OMWB_emulation.utilities.YEAR("hire_date") into s
FROM "emp"  WHERE "emp_id" = 'E63535';
dbms_output.put_line('Returned: ' || s);
END emp_year;

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