Hi All: FYI: Following post as a potential solution: http://lists.lsc-project.org/pipermail/lsc-users/2015-June/002587.html
Will give it a go - hesitant to add new code (due to an already existing complex environment - trying to maintain plain vanilla as much as possible). But above appears to be only pathway (short off an upcoming 12C upgrade - which will up varchar2, from 4K, to 32K). If anyone else has tried above - pls post any feedback - much appreciated. LSC is fantastic -- thank you for all your help! On Sun, Mar 20, 2016 at 10:29 PM, Joel Levin <[email protected]> wrote: > Hi All: > > I've been investigating options due to the 4000K limitation of LISTAGG > (for syncing membership from DB table to LDAP). > > From research online, XMLAGG appears to be an alternative - sample below. > > I'm stuck at how best to parse the XMLTYPE column of "members" via lsc.xml > ---- any tips or other better solutions? > > Thanks. > > > select > SPEC_GROUP_MEMBERSHIP as "cn", > XMLAGG(XMLELEMENT(E,LOGIN_NAME||',')).EXTRACT('//text()') as "members" > FROM MEMBERSHIP_TABLE > where > SPEC_GROUP_MEMBERSHIP = #cn# > GROUP BY SPEC_GROUP_MEMBERSHIP >
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
