73: LOOP
74: FETCH props INTO propName, propId;
75: EXIT WHEN props%NOTFOUND;
76:
77: val := IES_META_DATA_UTIL.getProperty(element, propName);
78:
79: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
80: execute immediate 'select ies_meta_property_values_s.nextval from dual' into propValue_id ;
81:
75: EXIT WHEN props%NOTFOUND;
76:
77: val := IES_META_DATA_UTIL.getProperty(element, propName);
78:
79: lookupId := IES_META_DATA_UTIL.getLookupId(propId, val);
80: execute immediate 'select ies_meta_property_values_s.nextval from dual' into propValue_id ;
81:
82: if (lookupId = -1) then
83: sqlStmt := 'INSERT INTO ies_meta_property_values (propval_id,
124: objTypeId NUMBER;
125:
126: sqlStmt varchar2(2000);
127: BEGIN
128: x_name := IES_META_DATA_UTIL.getProperty(element, 'name');
129: if (x_name is null) then
130: x_name := 'nullname';
131: end if;
132:
129: if (x_name is null) then
130: x_name := 'nullname';
131: end if;
132:
133: x_uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
134: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));
135:
136: sqlStmt := 'INSERT INTO ies_meta_objects (object_id,
137: name,
130: x_name := 'nullname';
131: end if;
132:
133: x_uid := IES_META_DATA_UTIL.getProperty(element, 'UID');
134: objtypeId := IES_META_DATA_UTIL.getObjectTypeId(xmldom.getAttribute(element, 'CLASS'));
135:
136: sqlStmt := 'INSERT INTO ies_meta_objects (object_id,
137: name,
138: object_uid,