I'm using Executestoredprocedure plugin in 21.3 version to execute stored procedure in Oracle database. The procedure using Cursor as out parameter to return select statement result.
I found out the open cursors are remaining open in database. Any thought to solve this issue?
Discussion posts and replies are publicly visible
I could see how this would make sense if the cursor is an out parameter to Appian. Is there a reason why you are returning a cursor? I generally like to return the data or an identifier that I need to work with a data set - especially to not put too much data into PVs to impact memory. Just an idea.
ChristineH Thank you for response. I need additional information to be displayed in the UI. The data sit in different schema with datastore's schema, otherwise I can just use Query entity to fetch the data. The reason I'm using open cursor because I was not aware the cursor remaining open after execution and can't find way to return the select result to Appian without using Out cursor.