DB function calls at Gel script is not working as expected

book

Article ID: 211370

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

I am trying to call a DB function at Gel script code. it's not returning the value. 

have tried the following approaches.

select A_FCT('AZN') rate from dual          
call A_FCT('AZN') (this is written in    <sql:update> clause)

exec A_FCT('AZN') 

wanted to confirm Gel script recognize the DB Function in the script. 

please provide the syntax incase it supports. 

 

 

Environment

Release : 15.8

Component : CA PPM XML OPEN GATEWAY (XOG)

Resolution

The DB function calling in Gel script is working as expected now. 
It was the issue with passing the Date parameter in gel.