Skip to Content
0
Nov 18, 2019 at 07:47 AM

How to pass the values through declare function in Hana

61 Views

DO Begin Declare Workingdays decimal(30,6); --Workingdays Select (Select "DocEntry" from OINV )into Workingdays from dummy; select * from OINV where "DocEntry" in (:Workingdays) ; End;

I need to pass mulitple values in through query

Error :

Could not execute 'DO Begin Declare Workingdays decimal(30,6); --Workingdays Select (Select "DocEntry" from OINV )into ...' in 15 ms 413 µs . SAP DBTech JDBC: [305]: single-row query returns more than one row: "INDRASFINAL"."DO": line 9 col 3 (at pos 79): [305] (range 3) single-row query returns more than one row exception: single-row query returns more than one row: ptime::PtimeException