242: AND s.set_id = c_set_id;
243:
244: CURSOR c5(c_set_id IN NUMBER) IS
245: SELECT DISTINCT category_id
246: FROM CS_KB_SOLN_CATEGORIES_B
247: START WITH category_id IN
248: (
249: SELECT category_id
250: FROM cs_kb_set_categories
616: p_clob IN OUT NOCOPY CLOB)
617: IS
618: CURSOR c5(c_set_id IN NUMBER) IS
619: SELECT DISTINCT category_id
620: FROM CS_KB_SOLN_CATEGORIES_B
621: START WITH category_id IN
622: (
623: SELECT category_id
624: FROM cs_kb_set_categories