This function returns the SQL cursor name.

 

Example:

SELECT GETCURSORNAME()

 

To embed it in a SELECT ... FOR UPDATE SQL statement, use the following syntax:

 

SELECT GETCURSORNAME(), CUSTOMERNAME FROM CUSTOMERS_TABLE WHERE CUSTOMERID = '12345' FOR UPDATE OF CUSTOMERNAME