My Oracle Support Banner

ODI Procedure Calling a SQL Server Custom Function Fails with Error ODI-1227 (Doc ID 2016948.1)

Last updated on NOVEMBER 08, 2018

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

There are custom functions in SQL Server. Attempting to execute a custom function in an ODI procedure fails with the following error:

 
  •  Execute the procedure

    • Changes

     The CWDecrypt is a custom function which was created in the SQL Server in catalog name "ClockworkDSS" and "dbo" schema.

    Cause

    To view full details, sign in with your My Oracle Support account.

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

    In this Document
    Symptoms
    Changes
    Cause
    Solution
    References


    My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.