263: ELSIF(p_context_flag = 'IDENTIFY' OR p_context_flag = 'POINT_FEATURE' OR p_context_flag = 'POINT_FEATURE_AT_LOCATION') THEN
264:
265: select SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(p_x_coord,p_y_coord,null),null,null)
266: into l_geometry 267: from dual; 268:
269: IF(p_context_flag = 'IDENTIFY') THEN
270: insert into RRS_SITE_TMP
271: (session_id,theme_id,geometry)