215: FETCH Get_Object_Query INTO l_query;
216: CLOSE Get_Object_Query;
217:
218: --dbms_output.put_line('Query :'||l_query);
219: l_cursor := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
216: CLOSE Get_Object_Query;
217:
218: --dbms_output.put_line('Query :'||l_query);
219: l_cursor := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
217:
218: --dbms_output.put_line('Query :'||l_query);
219: l_cursor := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
218: --dbms_output.put_line('Query :'||l_query);
219: l_cursor := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
226: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ext_obj_count);
219: l_cursor := DBMS_SQL.OPEN_CURSOR;
220: DBMS_SQL.PARSE(l_cursor, l_query, DBMS_SQL.NATIVE);
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
226: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ext_obj_count);
227: END IF;
221: DBMS_SQL.DEFINE_COLUMN(l_cursor, 1, l_ext_obj_count);
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
226: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ext_obj_count);
227: END IF;
228: DBMS_SQL.CLOSE_CURSOR(l_cursor);
229:
222: DBMS_SQL.BIND_VARIABLE(l_cursor, ':1',P_OTHER_ID);
223: l_return := DBMS_SQL.EXECUTE(l_cursor);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
226: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ext_obj_count);
227: END IF;
228: DBMS_SQL.CLOSE_CURSOR(l_cursor);
229:
230: --dbms_output.put_line('Obj count: '||l_ext_obj_count);
224:
225: IF DBMS_SQL.FETCH_ROWS(l_cursor)>0 THEN
226: DBMS_SQL.COLUMN_VALUE(l_cursor, 1, l_ext_obj_count);
227: END IF;
228: DBMS_SQL.CLOSE_CURSOR(l_cursor);
229:
230: --dbms_output.put_line('Obj count: '||l_ext_obj_count);
231:
232: EXCEPTION