Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Substring function returning an error

997624Jul 3 2014 — edited Jul 3 2014

Hello experts,

I have a column that the business users want to be broken into several columns... However, every time I try the string function I get the below error message.

[nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 4 expression on row count -1 failed. [nQSError: 59007] The length operand 0 of the SubString operator must be greater than zero

here is my query: SUBSTRING("Details"."Journal Description" FROM 1 FOR LOCATE('m', "Details"."Journal Description" ))

has anyone every encountered same issue, or have an idea how to resolve this... The data type for my column in the rpd is VARCHAR, I am not sure if that could be an issue. I have tried to change to DOUBLE or CHAR, no luck.

Please please help.

thx

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 31 2014

Added on Jul 3 2014

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee11g

5 comments

2,043 views