error in calling a procedure

[Former Member]

Hi Friends,

I have created aprocedure in HANA under content with two IN parameters.

I want to pass multiple values to the procedure in wich am trying to pass alphanumeric values also.But am unable to call the procedure

CALL Test.proc1('123,456' , ' 12AB , 23BC ' );

In which am passing multiple values for each IN prapameter. If i try below its working fine.

CALL Test.proc1('123,456');

Could some one please guide me how to pass Alphanumeric values to the procedure?? My scalar prarmeter type is NVARCHAR. I even tried ALPHANUM/BLOB/CBLOB but no result

ERROR:

SAP DBTech JDBC: [2048]: column store error: search table error:  [6968] Evaluator: syntax error in expression string;expected ASCT ,parsing " in(\"REC\", 123,456) AND in(\"GUID\", 4[here]12AB,23BC)

Best Regards,

Krishna

[Former Member]

Hi,

Can some one please tell me how to pass alphanumeric values to the procedure?

What data type i should consider while passing the alphanumeric values into HANA procedures.

Thank you.

Best Regards,

Krishna.

[former_member182302]

What was the error it was giving to you?

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

Am getting below error while calling the procedure.

SAP DBTech JDBC: [2048]: column store error: search table error:  [6968] Evaluator: syntax error in expression string;expected ASCT ,parsing " in(\"REC\", 123,456) AND in(\"GUID\", 4[here]12AB,23BC)

[lbreddemann]

Mind showing us the code of your procedure?

Without it this is going to be a funny guess game.