Skip to main content
D
dedip3799
June 1, 2022
Question

Executestoredprocedure open cursor

  • June 1, 2022
  • 2 replies
  • 0 views

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
    June 3, 2022

    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.

    D
    dedip3799Author
    June 3, 2022

    [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