Le 27/02/2016 01:08, Joel Levin a écrit :
Hi All:
Thank you again for all the great help w.r.t this fabulous tool.
I have the following in InetOrgPerson.xml
SELECT
SECTIONGROUP as "cn",
LISTAGG(LOGIN_NAME, '; ') WITHIN GROUP (ORDER BY LOGIN_NAME)
as "uid", DEPARTMENT_CD
FROM S2S_2015_2016_MVW
where
GROUP BY SECTIONGROUP, DEPARTMENT_CD"
The above generates ' ORA-01489: result of string concatenation is too
long' ---- this is a result of the SQL limitation of 4000 characters.
I can get around above via the following PL-SQL:
"create or replace procedure contact_name (in_section_name varchar2,
out_contact_nm out CLOB) as
v_tmp clob ;
begin
for i in (
SELECT LOGIN_NAME ||'; ' nm FROM
S2S_2015_2016_MVW
where SECTIONGROUP = in_section_name) loop
v_tmp := v_tmp||i.nm;
end loop;
out_contact_nm := rtrim(v_tmp,'; ');
end;"
I am a bit stumped getting this into the iBatis framework with
InetOrgPerson.xml -- can it be done or am I on a wrong track?
I know that you can call a stored procedure with iBatis, see
http://lists.lsc-project.org/pipermail/lsc-users/2015-April/002547.html
But I don't know if you can manager procedure on client side. The best
would be to use a procedure stored on server side.
--
Clément OUDOT
Consultant en logiciels libres, Expert infrastructure et sécurité
Savoir-faire Linux
87, rue de Turbigo - 75003 PARIS
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
