Hi,
I am using the INSTR parameter in the WHERE clause of the Query DB node. The code works fin in Dev, however, it's throwing the below error in Test.
"There was a problem executing the SQL query. SQL Message : ORA-01460: unimplemented or unreasonable conversion requested"
Below is the code that I am using.
"SELECT CLAIM_REFNUM AS CLAIM_REFNUM, max(PAYMENT_CLAIM_NUMBER) AS PAYMENT_CLAIM_NUMBER, max(PAYMENT_SCHEDULE_NUMBER) AS PAYMENT_SCHEDULE_NUMBER FROM <table>WHERE INSTR(',' || ac!paymentClaimRefNum || ',',',' || CLAIM_REFNUM || ',')>0 GROUP BY CLAIM_REFNUM"
ac!paymentClaimRefNum is a text variable defined as joinarray(pv!paymentClaimSummary_cdt.PAYMENT_CLAIM_ID,",")
pv!paymentClaimSummary_cdt.PAYMENT_CLAIM_ID is an array of string values. It returns 110 rows in Dev and 196 rows in Test.
I wonder if there is a limit on the input values passed in the IN parameter.
Any help would be appreciated
Thanks
Discussion posts and replies are publicly visible
Just a thought.
Please check if pv!paymentClaimSummary_cdt.PAYMENT_CLAIM_ID have any other special characters apart from below ones.
list of Character Set Support:
% ' ' ( ) * + - , . / \ : ; < > = ! _ & ~ { } | ^ ? $ # @ " [ ]
Hi Ricky, There are no special characters apart from _.