Calling procedure with input parameters in sap hana

5029 Views

Hi All,

I have written below procedure in HANA and trying to call.

CREATE PROCEDURE "PRICING"."TXN_03_STATS" LANGUAGE SQLSCRIPT AS

vDate_Beg date := '';

VDate_end date := '';

BEGIN

INSERT INTO SEGMENT_STATS ( SEGMENT_ID ,

REVENUE ,

PRICE_MEAN ,

PRICE_STDDEV ,

TRANSACTION_COUNT,

CUSTOMER_COUNT ,

PRODUCT_COUNT )

SELECT

SEGMENT_NUM ,

SUM( VLISTPRICE * (1 - DISCOUNT_PCT) * VQUANTITY),

AVG( VLISTPRICE * (1 - DISCOUNT_PCT) ),

STDDEV(VLISTPRICE * (1 - DISCOUNT_PCT) ),

COUNT( 1 ) ,

COUNT( DISTINCT SOLDTO ) ,

COUNT( DISTINCT MATERIALSKU)

FROM TXN

WHERE VDATE >= :vDate_Beg

AND VDATE <= :vDate_End

AND IS_LIST_PRICE = 'Y'

GROUP BY SEGMENT_NUM;

END;

I tried to execute below statements without luck.

call "PRICING"."TXN_03_STATS" ('2010-01-01','2013-03-31');

call "PRICING"."TXN_03_STATS" (?,?);

can anyone help me.

Regards,

Venkat