DBA Data[Home] [Help]

SYS.VALIDATE_ORDIM dependencies on DUAL

Line 44: select 'ORDIMAGE' name from dual

40: dbms_output.put_line('The following objects are not created:');
41:
42: for r in (
43: (
44: select 'ORDIMAGE' name from dual
45: union
46: select 'ORDAUDIO' name from dual
47: union
48: select 'ORDDOC' name from dual

Line 46: select 'ORDAUDIO' name from dual

42: for r in (
43: (
44: select 'ORDIMAGE' name from dual
45: union
46: select 'ORDAUDIO' name from dual
47: union
48: select 'ORDDOC' name from dual
49: union
50: select 'ORDVIDEO' name from dual

Line 48: select 'ORDDOC' name from dual

44: select 'ORDIMAGE' name from dual
45: union
46: select 'ORDAUDIO' name from dual
47: union
48: select 'ORDDOC' name from dual
49: union
50: select 'ORDVIDEO' name from dual
51: union
52: select 'ORDDICOM' name from dual

Line 50: select 'ORDVIDEO' name from dual

46: select 'ORDAUDIO' name from dual
47: union
48: select 'ORDDOC' name from dual
49: union
50: select 'ORDVIDEO' name from dual
51: union
52: select 'ORDDICOM' name from dual
53: union
54: select 'SI_COLOR' name from dual

Line 52: select 'ORDDICOM' name from dual

48: select 'ORDDOC' name from dual
49: union
50: select 'ORDVIDEO' name from dual
51: union
52: select 'ORDDICOM' name from dual
53: union
54: select 'SI_COLOR' name from dual
55: union
56: select 'SI_STILLIMAGE' name from dual

Line 54: select 'SI_COLOR' name from dual

50: select 'ORDVIDEO' name from dual
51: union
52: select 'ORDDICOM' name from dual
53: union
54: select 'SI_COLOR' name from dual
55: union
56: select 'SI_STILLIMAGE' name from dual
57: union
58: select 'SI_AVERAGECOLOR' name from dual

Line 56: select 'SI_STILLIMAGE' name from dual

52: select 'ORDDICOM' name from dual
53: union
54: select 'SI_COLOR' name from dual
55: union
56: select 'SI_STILLIMAGE' name from dual
57: union
58: select 'SI_AVERAGECOLOR' name from dual
59: union
60: select 'SI_COLORHISTOGRAM' name from dual

Line 58: select 'SI_AVERAGECOLOR' name from dual

54: select 'SI_COLOR' name from dual
55: union
56: select 'SI_STILLIMAGE' name from dual
57: union
58: select 'SI_AVERAGECOLOR' name from dual
59: union
60: select 'SI_COLORHISTOGRAM' name from dual
61: union
62: select 'SI_POSITIONALCOLOR' name from dual

Line 60: select 'SI_COLORHISTOGRAM' name from dual

56: select 'SI_STILLIMAGE' name from dual
57: union
58: select 'SI_AVERAGECOLOR' name from dual
59: union
60: select 'SI_COLORHISTOGRAM' name from dual
61: union
62: select 'SI_POSITIONALCOLOR' name from dual
63: union
64: select 'SI_TEXTURE' name from dual

Line 62: select 'SI_POSITIONALCOLOR' name from dual

58: select 'SI_AVERAGECOLOR' name from dual
59: union
60: select 'SI_COLORHISTOGRAM' name from dual
61: union
62: select 'SI_POSITIONALCOLOR' name from dual
63: union
64: select 'SI_TEXTURE' name from dual
65: union
66: select 'SI_FEATURELIST' name from dual

Line 64: select 'SI_TEXTURE' name from dual

60: select 'SI_COLORHISTOGRAM' name from dual
61: union
62: select 'SI_POSITIONALCOLOR' name from dual
63: union
64: select 'SI_TEXTURE' name from dual
65: union
66: select 'SI_FEATURELIST' name from dual
67: )
68: minus

Line 66: select 'SI_FEATURELIST' name from dual

62: select 'SI_POSITIONALCOLOR' name from dual
63: union
64: select 'SI_TEXTURE' name from dual
65: union
66: select 'SI_FEATURELIST' name from dual
67: )
68: minus
69: (
70: select o.name from sys.obj$ o, sys.user$ u

Line 123: select 'javax/media/jai/JAI' name, 'jai_core.jar' jar from dual

119: dbms_output.put_line('The following ORDIM Java libs are not loaded correctly:');
120:
121: for r in (
122: (
123: select 'javax/media/jai/JAI' name, 'jai_core.jar' jar from dual
124: union
125: select 'com/sun/media/jai/codec/ImageCodec' name, 'jai_codec.jar' jar from dual
126: union
127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual

Line 125: select 'com/sun/media/jai/codec/ImageCodec' name, 'jai_codec.jar' jar from dual

121: for r in (
122: (
123: select 'javax/media/jai/JAI' name, 'jai_core.jar' jar from dual
124: union
125: select 'com/sun/media/jai/codec/ImageCodec' name, 'jai_codec.jar' jar from dual
126: union
127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual
128: union
129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual

Line 127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual

123: select 'javax/media/jai/JAI' name, 'jai_core.jar' jar from dual
124: union
125: select 'com/sun/media/jai/codec/ImageCodec' name, 'jai_codec.jar' jar from dual
126: union
127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual
128: union
129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual
130: union
131: select 'oracle/ord/dicom/attr/DicomAttrTag' name, 'ordimdcm.jar' jar from dual

Line 129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual

125: select 'com/sun/media/jai/codec/ImageCodec' name, 'jai_codec.jar' jar from dual
126: union
127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual
128: union
129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual
130: union
131: select 'oracle/ord/dicom/attr/DicomAttrTag' name, 'ordimdcm.jar' jar from dual
132: union
133: select 'oracle/ord/media/annotator/servclt/AnnCltInServer' name, 'ordimann.jar' jar from dual

Line 131: select 'oracle/ord/dicom/attr/DicomAttrTag' name, 'ordimdcm.jar' jar from dual

127: select 'com/sun/medialib/mlib/mediaLibImage' name, 'mlibwrapper_jai.jar' jar from dual
128: union
129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual
130: union
131: select 'oracle/ord/dicom/attr/DicomAttrTag' name, 'ordimdcm.jar' jar from dual
132: union
133: select 'oracle/ord/media/annotator/servclt/AnnCltInServer' name, 'ordimann.jar' jar from dual
134: )
135: minus

Line 133: select 'oracle/ord/media/annotator/servclt/AnnCltInServer' name, 'ordimann.jar' jar from dual

129: select 'oracle/ord/media/img/PropsAdapter' name, 'ordimimg.jar' jar from dual
130: union
131: select 'oracle/ord/dicom/attr/DicomAttrTag' name, 'ordimdcm.jar' jar from dual
132: union
133: select 'oracle/ord/media/annotator/servclt/AnnCltInServer' name, 'ordimann.jar' jar from dual
134: )
135: minus
136: (
137: select nvl(j.longdbcs, o.name) name,

Line 244: select 'http://xmlns.oracle.com/ord/meta/ordimage' schema_url from dual

240: dbms_output.put_line('The following XML schemas are not registered:');
241:
242: for r in (
243: (
244: select 'http://xmlns.oracle.com/ord/meta/ordimage' schema_url from dual
245: union
246: select 'http://xmlns.oracle.com/ord/meta/exif' schema_url from dual
247: union
248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual

Line 246: select 'http://xmlns.oracle.com/ord/meta/exif' schema_url from dual

242: for r in (
243: (
244: select 'http://xmlns.oracle.com/ord/meta/ordimage' schema_url from dual
245: union
246: select 'http://xmlns.oracle.com/ord/meta/exif' schema_url from dual
247: union
248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual
249: union
250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual

Line 248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual

244: select 'http://xmlns.oracle.com/ord/meta/ordimage' schema_url from dual
245: union
246: select 'http://xmlns.oracle.com/ord/meta/exif' schema_url from dual
247: union
248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual
249: union
250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual
251: union
252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual

Line 250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual

246: select 'http://xmlns.oracle.com/ord/meta/exif' schema_url from dual
247: union
248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual
249: union
250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual
251: union
252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual
253: union
254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual

Line 252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual

248: select 'http://xmlns.oracle.com/ord/meta/iptc' schema_url from dual
249: union
250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual
251: union
252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual
253: union
254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual
255: union
256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual

Line 254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual

250: select 'http://xmlns.oracle.com/ord/meta/xmp' schema_url from dual
251: union
252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual
253: union
254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual
255: union
256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual
257: union
258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual

Line 256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual

252: select 'http://xmlns.oracle.com/ord/meta/dicomImage' schema_url from dual
253: union
254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual
255: union
256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual
257: union
258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual
259: union
260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual

Line 258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual

254: select 'http://xmlns.oracle.com/ord/dicom/rpdatatype_1_0' schema_url from dual
255: union
256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual
257: union
258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual
259: union
260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual
261: union
262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual

Line 260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual

256: select 'http://xmlns.oracle.com/ord/dicom/datatype_1_0' schema_url from dual
257: union
258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual
259: union
260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual
261: union
262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual
263: union
264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual

Line 262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual

258: select 'http://xmlns.oracle.com/ord/dicom/mddatatype_1_0' schema_url from dual
259: union
260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual
261: union
262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual
263: union
264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual
265: union
266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual

Line 264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual

260: select 'http://xmlns.oracle.com/ord/dicom/anonymity_1_0' schema_url from dual
261: union
262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual
263: union
264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual
265: union
266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual
267: union
268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual

Line 266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual

262: select 'http://xmlns.oracle.com/ord/dicom/attributeTag_1_0' schema_url from dual
263: union
264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual
265: union
266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual
267: union
268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual
269: union
270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual

Line 268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual

264: select 'http://xmlns.oracle.com/ord/dicom/constraint_1_0' schema_url from dual
265: union
266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual
267: union
268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual
269: union
270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual
271: union
272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual

Line 270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual

266: select 'http://xmlns.oracle.com/ord/dicom/metadata_1_0' schema_url from dual
267: union
268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual
269: union
270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual
271: union
272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual
273: union
274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual

Line 272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual

268: select 'http://xmlns.oracle.com/ord/dicom/mapping_1_0' schema_url from dual
269: union
270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual
271: union
272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual
273: union
274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual
275: union
276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual

Line 274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual

270: select 'http://xmlns.oracle.com/ord/dicom/manifest_1_0' schema_url from dual
271: union
272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual
273: union
274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual
275: union
276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual
277: union
278: select 'http://xmlns.oracle.com/ord/dicom/orddicom_1_0' schema_url from dual

Line 276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual

272: select 'http://xmlns.oracle.com/ord/dicom/preference_1_0' schema_url from dual
273: union
274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual
275: union
276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual
277: union
278: select 'http://xmlns.oracle.com/ord/dicom/orddicom_1_0' schema_url from dual
279: union
280: select 'http://xmlns.oracle.com/ord/dicom/UIDdefinition_1_0' schema_url from dual

Line 278: select 'http://xmlns.oracle.com/ord/dicom/orddicom_1_0' schema_url from dual

274: select 'http://xmlns.oracle.com/ord/dicom/privateDictionary_1_0' schema_url from dual
275: union
276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual
277: union
278: select 'http://xmlns.oracle.com/ord/dicom/orddicom_1_0' schema_url from dual
279: union
280: select 'http://xmlns.oracle.com/ord/dicom/UIDdefinition_1_0' schema_url from dual
281: )
282: minus

Line 280: select 'http://xmlns.oracle.com/ord/dicom/UIDdefinition_1_0' schema_url from dual

276: select 'http://xmlns.oracle.com/ord/dicom/standardDictionary_1_0' schema_url from dual
277: union
278: select 'http://xmlns.oracle.com/ord/dicom/orddicom_1_0' schema_url from dual
279: union
280: select 'http://xmlns.oracle.com/ord/dicom/UIDdefinition_1_0' schema_url from dual
281: )
282: minus
283: (
284: select schema_url from sys.all_xml_schemas

Line 350: select 'ordcman.xml' doc_name from dual

346: dbms_output.put_line('The following default DICOM repository documents are not installed:');
347:
348: for r in (
349: (
350: select 'ordcman.xml' doc_name from dual
351: union
352: select 'ordcmcmc.xml' doc_name from dual
353: union
354: select 'ordcmcmd.xml' doc_name from dual

Line 352: select 'ordcmcmc.xml' doc_name from dual

348: for r in (
349: (
350: select 'ordcman.xml' doc_name from dual
351: union
352: select 'ordcmcmc.xml' doc_name from dual
353: union
354: select 'ordcmcmd.xml' doc_name from dual
355: union
356: select 'ordcmct.xml' doc_name from dual

Line 354: select 'ordcmcmd.xml' doc_name from dual

350: select 'ordcman.xml' doc_name from dual
351: union
352: select 'ordcmcmc.xml' doc_name from dual
353: union
354: select 'ordcmcmd.xml' doc_name from dual
355: union
356: select 'ordcmct.xml' doc_name from dual
357: union
358: select 'ordcmmp.xml' doc_name from dual

Line 356: select 'ordcmct.xml' doc_name from dual

352: select 'ordcmcmc.xml' doc_name from dual
353: union
354: select 'ordcmcmd.xml' doc_name from dual
355: union
356: select 'ordcmct.xml' doc_name from dual
357: union
358: select 'ordcmmp.xml' doc_name from dual
359: union
360: select 'ordcmpf.xml' doc_name from dual

Line 358: select 'ordcmmp.xml' doc_name from dual

354: select 'ordcmcmd.xml' doc_name from dual
355: union
356: select 'ordcmct.xml' doc_name from dual
357: union
358: select 'ordcmmp.xml' doc_name from dual
359: union
360: select 'ordcmpf.xml' doc_name from dual
361: union
362: select 'ordcmpv.xml' doc_name from dual

Line 360: select 'ordcmpf.xml' doc_name from dual

356: select 'ordcmct.xml' doc_name from dual
357: union
358: select 'ordcmmp.xml' doc_name from dual
359: union
360: select 'ordcmpf.xml' doc_name from dual
361: union
362: select 'ordcmpv.xml' doc_name from dual
363: union
364: select 'ordcmsd.xml' doc_name from dual

Line 362: select 'ordcmpv.xml' doc_name from dual

358: select 'ordcmmp.xml' doc_name from dual
359: union
360: select 'ordcmpf.xml' doc_name from dual
361: union
362: select 'ordcmpv.xml' doc_name from dual
363: union
364: select 'ordcmsd.xml' doc_name from dual
365: union
366: select 'ordcmui.xml' doc_name from dual

Line 364: select 'ordcmsd.xml' doc_name from dual

360: select 'ordcmpf.xml' doc_name from dual
361: union
362: select 'ordcmpv.xml' doc_name from dual
363: union
364: select 'ordcmsd.xml' doc_name from dual
365: union
366: select 'ordcmui.xml' doc_name from dual
367: )
368: minus

Line 366: select 'ordcmui.xml' doc_name from dual

362: select 'ordcmpv.xml' doc_name from dual
363: union
364: select 'ordcmsd.xml' doc_name from dual
365: union
366: select 'ordcmui.xml' doc_name from dual
367: )
368: minus
369: (
370: select doc_name from orddata.orddcm_docs