Skip to main content
dedip3799
New Participant
Jun 1, 2022 3:29 PM UTC
Question

Executestoredprocedure open cursor

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?

    2 replies

    christineh465186
    christineh465186
    Participating Frequently
    Jun 3, 2022 6:48 PM UTC

    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.

    dedip3799Author
    New Participant
    Jun 3, 2022 9:07 PM UTC

    [mention:d4a91cb869574be08f6b7a5ae536a638:e9ed411860ed4f2ba0265705b8793d05] 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.

    Terms & ConditionsAccessibility statement