DBA Data[Home] [Help]

MDSYS.SDO_ROUTER_PARTITION dependencies on STRING_ARRAY

Line 1176: rets OUT mdsys.string_array,

1172: ---
1173: ---
1174: FUNCTION get_edge_info(edge_ids IN sdo_list_type,
1175: to_edge_ids OUT sdo_list_type,
1176: rets OUT mdsys.string_array,
1177: angle_segments OUT sdo_list_type)
1178: RETURN mdsys.string_array AS
1179: n INTEGER;
1180: i INTEGER;

Line 1178: RETURN mdsys.string_array AS

1174: FUNCTION get_edge_info(edge_ids IN sdo_list_type,
1175: to_edge_ids OUT sdo_list_type,
1176: rets OUT mdsys.string_array,
1177: angle_segments OUT sdo_list_type)
1178: RETURN mdsys.string_array AS
1179: n INTEGER;
1180: i INTEGER;
1181: k INTEGER;
1182: base INTEGER := 1;

Line 1185: names mdsys.string_array;

1181: k INTEGER;
1182: base INTEGER := 1;
1183: to_edge_id INTEGER;
1184: coords mdsys.sdo_ordinate_array;
1185: names mdsys.string_array;
1186: name_query VARCHAR2(2000);
1187: sign_query VARCHAR2(2000);
1188: ret VARCHAR2(200);
1189: TYPE cursor_type IS REF CURSOR;

Line 1198: names := mdsys.string_array();

1194: END IF;
1195:
1196: -- Initialize varrays
1197: n := edge_ids.count;
1198: names := mdsys.string_array();
1199: to_edge_ids := sdo_list_type();
1200: rets := mdsys.string_array();
1201: angle_segments := sdo_list_type();
1202: names.extend(n);

Line 1200: rets := mdsys.string_array();

1196: -- Initialize varrays
1197: n := edge_ids.count;
1198: names := mdsys.string_array();
1199: to_edge_ids := sdo_list_type();
1200: rets := mdsys.string_array();
1201: angle_segments := sdo_list_type();
1202: names.extend(n);
1203: to_edge_ids.extend(n);
1204: rets.extend(n);