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
