Skip to Content
0
Jun 03, 2020 at 10:12 AM

How to call a stored procedure through insert query in sap HANA ?

229 Views

Actually Query in SQL :

Insert into #HRMS_PROVISION (EmpID) Exec [@SMS_SP_Employee-wise_End_of_Service] @asondate

Converted Query in HANA:

Insert into #HRMS_PROVISION (EmpID) call "@SMS_SP_Employee-wise_End_of_Service" (:asondate);

Error msg in sql console

SAP DBTech JDBC: [7]: feature not supported: INSERT CALL

help me on this to resolve this error and give a alternate solution.