SG-1140 CLONE - Base - Cursor leak in O7FLXPKG - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

SG-1140 CLONE - Base - Cursor leak in O7FLXPKG

 Description 

There is a cursor-leak in procedure 07flxexec when a PL/SQL flextriggers exits with a -20003 user defined exception. The (dynamic) cursor \\"r5flexsql_cursor\\" is not closed.

*Steps to reproduce:*

# define a PL/SQL flextrigger on a table to trigger a -20003 application error

# create a loop to insert op update data

# check the open cursors

*Expected result:*

Cursor is closed

*Actual result:*

the EXIT statement breaks out of the FOR-LOOP- so the close_cursor that follows is NOT executed when the ORA-20003 occurs.

SG-1122 Work Orders | Book Labor | Copy Record - Does not copy the Trade field even though there is value if this field is not displayed in the dataspy