Skip to Content
Oct 14, 2019 at 07:02 AM

SAP HANA Stored procedure without any input parameter

215 Views Last edit Oct 14, 2019 at 07:16 AM 2 rev

I need to create a stored procedure that updates the root account id for a account in a table. Mainly I can use ancestor hierarchy function to find the root node for each account , but how can I find the root account id and update that for each account in my table if that needs to be done for each and every record of a table, and without passing any input parameter in the procedure. Can I use for loop on the table and fetch each record and then find its root account and update ?