2018-12-09 16:12:54 UTC
I use Connector Loop (JDBC Connector) for lookup user's permissions by Iterate Mode by this useful guide - http://www.tdiingoutloud.com/2013/09/using-connector-loop-to-replace.html.
All work fine till number iterations less than 1000, after these number I have SQLexeption: "ORA-01000: maximum open cursors exceeded".
I've tried to empty work.removeAllAttributes() in Before GetNext hook as explained by http://www.tdiingoutloud.com/2013/11/connector-loops.html
but not luck.
May be exist someone solution for this?