getting ODBC error

  Hi All,

     I have ran the report and I am getting the ODBC error.

  ERROR:

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 59007] The length operand -17 of the SubString operator must be greater than zero. (HY000)

I have raised SR with Oracle and they told that you are using in the Substring function (for), is not supported. But the function is residing in the report more than 3 years. After R 23 upgradation only its not working.

  Please find the expression below which we have used in the report.

Substring("- Service Request Custom Attributes".TEXT_35 from Position('/' IN "- Service Request Custom Attributes".TEXT_35)+9 for length ("- Service Request Custom Attributes".TEXT_35) - (position(':' IN "- Service Request Custom Attributes".TEXT_35)))