3:
4: FUNCTION GET_CONC_PAGES_BY_REQUEST_SET( P_SET_NAME VARCHAR2)
5: RETURN VARCHAR2
6: IS
7: CURSOR C_PAGES ( P_SET_NAME bis_request_set_objects_v.user_object_name%type )
8: IS
9: select
10: user_object_name
11: from
8: IS
9: select
10: user_object_name
11: from
12: bis_request_set_objects_v
13: where request_set_name = P_SET_NAME;
14: l_page_name bis_request_set_objects_v.user_object_name%type;
15: l_page_name_conc VARCHAR2(32767);
16:
10: user_object_name
11: from
12: bis_request_set_objects_v
13: where request_set_name = P_SET_NAME;
14: l_page_name bis_request_set_objects_v.user_object_name%type;
15: l_page_name_conc VARCHAR2(32767);
16:
17: begin
18: open C_PAGES(P_SET_NAME);