Skip to Content
0
Jul 17, 2019 at 06:25 PM

Why cannot use LOOPs inside Cursor of Transaction Notification Stored Procedure

155 Views Last edit Jul 17, 2019 at 06:26 PM 2 rev

Hello guys,

Im Trying to use a FOR loop inside a CURSOR in my Transaction Notification procedure with Hana DB.

But i just can`t use, it shows to me "Invalid Identifier" error JDBC 383. But the syntax is correct, i already used this in other procedures.

Im getting this error on "linha" variable.

ApproversProfile is the CURSOR I declared before.

FOR linha AS ApproversProfile DO
    -- Some code here
END FOR;

Anyone can help me?

Thanks,

Lucas Antoni.