1960: end if;
1961:
1962: -- Write value to fake clob and return
1963: if (value is null) then
1964: -- Dbms_lob raises error if value is null...
1965: return(null);
1966: else
1967: dbms_lob.createtemporary(tempclob, TRUE, dbms_lob.session);
1968: dbms_lob.write(tempclob, lengthb(value), 1, value);
1963: if (value is null) then
1964: -- Dbms_lob raises error if value is null...
1965: return(null);
1966: else
1967: dbms_lob.createtemporary(tempclob, TRUE, dbms_lob.session);
1968: dbms_lob.write(tempclob, lengthb(value), 1, value);
1969: return(tempclob);
1970: end if;
1971:
1964: -- Dbms_lob raises error if value is null...
1965: return(null);
1966: else
1967: dbms_lob.createtemporary(tempclob, TRUE, dbms_lob.session);
1968: dbms_lob.write(tempclob, lengthb(value), 1, value);
1969: return(tempclob);
1970: end if;
1971:
1972: exception
2752: end if;
2753: end if;
2754:
2755: -- Make fake clob to hold result
2756: dbms_lob.createtemporary(tempclob, TRUE, dbms_lob.session);
2757:
2758: -- Build clob with contents based on attr type
2759: if (atype = '###NOTDONE') then
2760: -- Parse out document subtypes
2764: value := WF_Engine.GetActivityAttrText(itemtype, itemkey, actid, aname);
2765: end if;
2766:
2767: -- Write value to fake clob and return
2768: dbms_lob.write(tempclob, lengthb(value), 1, value);
2769: return(tempclob);
2770:
2771: exception
2772: when others then