Analytics Software

Hello,

We have two columns START_DATE and END_DATE in the database table. We need to get those values from the table and assign those values to the Global Variables defined in ODI through Procedure.

We did in the following way:

Created a Procedure:

Command on Source:

"SELECT START_DATE,END_DATE FROM DATE_RANGE
WHERE MODULE_NAME='DEMO'"

Command on Target: Technology => 'Sunposis API'

DEMO_FUN($(ST_DATE),$(ED_DATE))

We have created DEMO_FUN Function as Global and in the implementation part we selected all the technologies:

BEGIN
#G_START_DATE=$(ST_DATE);
#G_END_DATE=$(ED_DATE);
END;

#G_START_DATE and #G_END_DATE are the Global Variables in ODI.

Getting the following error when we execute the above procedure:

Oracle Data Integrator Function does not exist

Do we made any mistake in above process or any other process we need to approach in order to meet our criteria?

Thanks,

-Vency