We are using a User Defined Function Substitution.Qualify() function. This function takes the table name input and returns the SchemaName.TableName.
syntax is QUALIFY($(VALUE)).
The Oracle implementation is as below
However for some environment it is returning me "SchemaName".TableName. Where a pair of double quote is coming extra.
This is causing issue while executing it at oracle side as Oracle doesnt expect schema info inside "".
Have anybody faced the similar issue. Any suggestion to resolve this issue.