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 and later
Information in this document applies to any platform.
***Checked for relevance on 02-May-2013***


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
     INSERT INTO myTable VALUES (...);
     RETURN 'OK';


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