[lsc-users] PL_SQL with iBatis

[Joel Levin]

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?

Thanks.

_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org

lsc-users mailing list
lsc-users@lists.lsc-project.org
http://lists.lsc-project.org/listinfo/lsc-users