ORA-14551 Message Is Displayed When Calling An Oracle Stored Function From ODI (Doc ID 424404.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.
***Checked for relevance on 02-May-2013***

Symptoms

The following message is signaled when an Oracle Stored Function is used within a SELECT instruction from Oracle Data Integrator (ODI):

ORA-14551: cannot perform a DML operation inside a query

The Oracle Stored Function is:

FUNCTION myFunction
RETURN varchar2
IS
BEGIN
     INSERT INTO myTable VALUES (...);
     COMMIT;
     RETURN 'OK';
END;

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