Execution of statements with HOLD_CURSORS_OVER_COMMIT must not be allowed in a global transaction. Currently, this is allowed when the statement is inside a stored procedure.
e.g: The following procedure should throw an error when executed inside a global transaction. However, no error is thrown when running with embedded or client drivers.
//Java method for stored procedure with HOLD_CURSORS_OVER_COMMIT
public static void testHoldCursorsProc(ResultSet rs) throws Exception