Skip to Content
0
Former Member
Feb 18, 2015 at 12:55 PM

Can we call a CV with input parameters in HANA procedure

649 Views

HI Experts

1. I have created a Calculation View with two input parameters

2, Now I have created a procedure with two input parameters

3. Now I want to call the calcview in my procedure passing the input parameters created in my procedure

syntax

begin

it_out = select * from calcview ( 'PLACEHOLDER' = ( '$$input1$$ ', :ip_input1 ),

'PLACEHOLDER' = ( '$$input2$$ ', :ip_input2 ) );

end;

Is my approch correct ?

Can we call view from procedure

Thanks

Pawan Akella