on 10-29-2014 7:11 AM
Hi Team,
I'm passing multiple input values in one of my stored procedure, it is working fine only when I pass either numeric or alphabets to a field.
it_proj_his = CE_PROJECTION(:it_ct_his, [HISTORYID, RECORD_ID, XN_GUID, COND_RATE, COGS_RATE, CANCEL_IND], ' in("RECORD_ID", :IP_RECORD_ID) AND in("XN_GUID", :IP_XN_GUID) AND "CANCEL_IND" != ''X'' ');
If I pass alphanumeric values to a field, it returns the syntax error.
call "_SYS_BIC"."CRM.PB/PROC_PB_QTY_MRMS"('1006059910,1002830256',
'4C40E989825462E0E10000000AB40A10,4E947D45D4BC04D8E10000000AB40A10',null);
Syntax error as follows:
SAP DBTech JDBC: [2048]: column store error: search table error: [6968] Evaluator: syntax error in expression string;expected TK_RPAREN,parsing " in(\"RECORD_ID\", 1006059910,1002830256) AND in(\"XN_GUID\", 4[here]C40E989825462E0E10000000AB40A10,4E947D45D4BC04D8E10000000AB40A10) AND \"CANCEL_IND\" != 'X' "
I tried changing the data type from NVARCHAR to ALPHANUM for a field, still doesn't work. Please help me resolving this issue.
Thanks for your help in Advance.
Regards,
Sathish
hi sathish, were you able to solve this? i am also having this issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.