My Oracle Support Banner

OEMM Does Not Recognize Sqlexception Handler from Teradata Procedure (Doc ID 2388370.1)

Last updated on APRIL 23, 2018

Applies to:

Oracle Enterprise Metadata Management - Version 12.2.1.2 and later
Information in this document applies to any platform.

Symptoms

Oracle Enterprise Metadata Management (OEMM) 12.2.1.2 does not recognize SQLEXCEPTION Handler on Teradata store procedure. When Teradata store procedure contains a piece of code similar to:

replace procedure PROCEDURE_NAME(in end_date date,out ret_code int,in parent_session_id char(16))
begin
    declare session_id char(16);
    declare exit handler for sqlexception
begin
...
...

Then, the following error occurs in the harvesting log:

[2018-04-09 20:42:09]  Expression syntax not recognized (or not supported) for 'sample.sql/PROCEDURE_NAME'. Some lineage metadata will not be available.
Debug [2018-04-09 20:42:09]  Message: 'syntax error, unexpected BEGIN_TOKEN, expecting IN_TOKEN'
Context: 'for sqlexception
begin'
Location: '(6,3,6,8)'
Expression tool type: 'Generic'
Expression database type: 'Teradata'
Expression text: 'replace procedure PROCEDURE_NAME(in end_date date,out ret_code int,in parent_session_id char(16))

 

Changes

 

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!


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