1 Reply Latest reply: Nov 27, 2012 4:14 AM by Bhabani Ranjan RSS

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

    974336
      Hi

      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
      <%=odiRef.getObjectName("L","$(VALUE)","D")%>

      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.

      Regards
      DBS