1 Reply Latest reply on Nov 27, 2012 10:14 AM by Bhabani Ranjan Mahapatra

    odiRef.getObjectName() returns me value with " "(double quote)


      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.