[Home] [Help]
PACKAGE: MDSYS.SDO_WFS_PROCESS
Source
1 PACKAGE SDO_WFS_PROCESS AUTHID current_user AS
2 SPATIALCOLSEP varchar2(40) := '<>';
3 SPATIALPATHELEMSEP varchar2(20) := '>';
4 NS_SEP varchar2(20) := '<';
5 NULL_NS varchar2(20) := 'null';
6 KEY_SEP varchar2(20) := ';';
7 COMMIT_THRESHOLD number := 1000;
8 LARGE_THRESHOLD number := 0;
9
10 -- publish from relation table content
11 procedure publishFeatureType(dataSrc IN VARCHAR2,
12 ftnsUrl IN VARCHAR2,
13 ftName IN VARCHAR2,
14 ftnsAlias IN VARCHAR2,
15 featureDesc IN XMLType,
16 SCHEMALOCATION IN VARCHAR2,
17 pkeyCol IN VARCHAR2,
18 columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
19 ftXSD IN XMLType default NULL/*,
20 ftVaryingNSAlias_ColName IN StringList default NULL*/,
21 customSrsNamePrefixes IN VARCHAR2 default NULL) ;
22 procedure publishFeatureType(dataSrc IN VARCHAR2,
23 ftnsUrl IN VARCHAR2,
24 ftName IN VARCHAR2,
25 ftnsAlias IN VARCHAR2,
26 featureDesc IN XMLType,
27 SCHEMALOCATION IN VARCHAR2,
28 pkeyCol IN VARCHAR2,
29 columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, viewTableName varchar2, viewTablepkeyCol varchar2, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
30 ftXSD IN XMLType default NULL/*,
31 ftVaryingNSAlias_ColName IN StringList default NULL*/,
32 customSrsNamePrefixes IN VARCHAR2 default NULL) ;
33 -- publish from a external feature xsd
34 procedure publishFeatureType(dataSrc IN VARCHAR2,
35 ftnsUrl IN VARCHAR2,
36 ftName IN VARCHAR2,
37 ftnsAlias IN VARCHAR2,
38 featureDesc IN XMLType,
39 SCHEMALOCATION IN VARCHAR2,
40 pkeyCol IN VARCHAR2,
41 columnInfo IN mdsys.StringList, pSpatialCol varchar2, featureMemberNS varchar2, featureMemberName varchar2, srsNS varchar2, srsNSAlias varchar2, featureCollectionNS varchar2, featureCollectionName varchar2, isGML3 varchar2, formattedkeyCols mdsys.StringList, viewTableName varchar2, viewTablepkeyCol varchar2, viewTableFmtKeyCols mdsys.StringList, mandatoryColumnInfo IN mdsys.StringList default mdsys.StringList('$ALL$'), wfs_version IN varchar2 default '1.0.0',
42 ftXSD IN XMLType default NULL/*,
43 ftVaryingNSAlias_ColName IN StringList default NULL*/,
44 customSrsNamePrefixes IN VARCHAR2 default NULL) ;
45 function populateVaryingAliases(ftXSD IN XMLType,
46 ftName IN VARCHAR2,
47 featureTypeId IN NUMBER,
48 col_name IN VARCHAR2,
49 tagTypeName OUT VARCHAR2) return varchar2;
50 function strip_special_chars(input_str varchar2,
51 chars_to_be_deleted varchar2,
52 placeholders varchar2 default CHR(1)) return varchar2;
53 procedure publish_featureTypes_in_schema(
54 p_owner varchar2,
55 p_namespace_url varchar2,
56 p_namespace_alias varchar2,
57 p_wls_postxml_url varchar2,
58 p_tablename_pattern varchar2 default '%',
59 p_wfs_version varchar2 default '1.1.0',
60 p_write_xsd varchar2 default 'N');
61 -- publish from a external feature xsd
62 procedure publishFeatureType(ftxsd IN XMLType, featureDesc IN XMLType, wfs_version IN varchar2 default '1.0.0');
63 procedure processInLineComplexElement(ftxsd IN XMLType,
64 elementXml IN XMLType,
65 elemIndex IN number,
66 spatialCols IN OUT NOCOPY mdsys.StringList,
67 currGmlElementsCnt IN OUT number,
68 gmlElementsCnt IN number,
69 parentElemPath IN varchar2,
70 gmlAlias IN VARCHAR2);
71 procedure processComplexElement(ftxsd IN XMLType,
72 elementType IN varchar2,
73 spatialCols IN OUT NOCOPY mdsys.StringList,
74 currGmlElementsCnt IN OUT number,
75 gmlElementsCnt IN number,
76 parentElemPath IN varchar2,
77 gmlAlias IN VARCHAR2);
78 function isComplexObjectType(elemType IN VARCHAR2, gmlAlias IN VARCHAR2) return number ;
79 function isInList(l mdsys.StringList, item varchar2) return number ;
80 function orderInList(l mdsys.StringList, item varchar2) return number ;
81
82 procedure registerObject(objNs IN VARCHAR2, objName IN VARCHAR2, ftnsUrl IN VARCHAR2, currObjColPath varchar2, objNameIndex IN NUMBER, ftId IN NUMBER, spatialColInfo mdsys.StringList, spatialColInfoIndex IN OUT NUMBER);
83 function getXMLTagType(typeOwner IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;
84 procedure dropFeatureType(ftnsUrl IN VARCHAR2, ftName IN VARCHAR2);
85 procedure dropFeatureTypes(ftnsUrl IN VARCHAR2);
86 procedure insertFtMDUpdated(ns varchar2, name varchar2, updateTs timestamp) ;
87 procedure insertFtDataUpdated(ns varchar2, name varchar2, updatedRowList ROWPOINTERLIST, updateTs timestamp);
88 procedure insertCapabilitiesInfo(capabilitiesInfo xmltype, wfs_version IN varchar2 default '1.0.0');
89 procedure deleteCapabilitiesInfo;
90 procedure genCollectionProcs ;
91 procedure genCollectionProcsHelper(objNs IN VARCHAR2, objName IN VARCHAR2) ;
92 procedure populateFeatureTypeXMLInfo(xmlcoltypexsd XMLType,
93 fTypeId number, columnName varchar2,
94 objPathInfo mdsys.StringList) ;
95 procedure deleteFeatureTypeXMLInfo(fTypeId number);
96 function containsSDO(ns varchar2, name varchar2, ftId number) return number;
97 function containsSDOInternal(rootns varchar2, rootname varchar2,
98 ns varchar2, name varchar2, ftId number) return number ;
99 procedure updateObjectRef(refObjNs varchar2, refObjName varchar2, featureTypeId number , refObjSeqNo number) ;
100 procedure updateObjectRef(refObjNs varchar2, refObjName varchar2,
101 refObjSeqNo number, nsUrl varchar2,
102 containerObjNs varchar2, containerObjName varchar2, containerObjNameIndex number, featureTypeId number) ;
103 function sortSpContentByColIndex (spatialPaths mdsys.StringList, spatialPathInfo sdo_geom_path_info,
104 userName varchar2, tableName in varchar2) return sdo_geom_path_info;
105 function genSpatialPathElemColIndex(spatialPaths mdsys.StringList, spatialPathElem sdo_geom_path_elem) return number ;
106 function genIdValue(data xmltype, idPaths mdsys.StringList, tNS varchar2, tName varchar2, ftUserName varchar2) return varchar2 ;
107 function getPath(path mdsys.StringList) return varchar2;
108 function getParsedPath(path varchar2) return mdsys.StringList; -- (ns1, name1, ns2, name2....)
109 procedure genRecordTypeProcessingLogic(tNS varchar2, tName varchar2) ;
110 function extractSDO(xmldata XMLType, spatialPaths mdsys.StringList, srsNs varchar2, ISGML3 varchar2, spPathsSRSNSList mdsys.StringListList) return sdo_geom_path_info ;
111 function parsePath(path varchar2) return mdsys.StringList ;
112 function generateParsedSpatialPath(spatialPaths mdsys.StringList) return mdsys.StringListList ;
113 function processPath(srcPaths mdsys.StringListList, genArrIdx number) return mdsys.StringListList ;
114 function generateAliasString(aliasList mdsys.StringList) return varchar2 ;
115 function getAlias(nsurl varchar2, aliasList mdsys.StringList) return varchar2 ;
116 function putAlias (nsurl varchar2, alias varchar2, aliasList mdsys.StringList) return mdsys.StringList;
117 function isRowIdIn (r ROWID, rlist RowPointerList) return number ;
118 function isPKColIn (r varchar2, rlist RowPointerList) return number;
119 function extractID(xmldata XMLType, idPaths mdsys.StringList) return varchar2 ;
120 function processIdPath(srcPaths mdsys.StringList) return mdsys.StringList ;
121
122 function getFeatureTypeId(ftnsUrl IN VARCHAR2,
123 ftName IN VARCHAR2) return number;
124 procedure grantMDAccessToAdminUser(userName IN varchar2) ;
125 procedure grantMDAccessToUser(userName IN varchar2);
126 procedure revokeMDAccessFromAdminUser(userName IN varchar2) ;
127 procedure revokeMDAccessFromUser(userName IN varchar2);
128 procedure grantFeatureTypeToUser(ftnsUrl IN VARCHAR2,
129 ftName IN VARCHAR2,
130 userName IN varchar2);
131 procedure revokeFeatureTypeFromUser(ftnsUrl IN VARCHAR2,
132 ftName IN VARCHAR2,
133 userName IN varchar2);
134 procedure registerMTableView(ftNSUrl varchar2,
135 ftName varchar2,
136 viewTableList mdsys.StringList,
137 viewTablePkeyColList mdsys.StringList,
138 tablePKeyColList mdsys.StringList);
139 procedure registerMTableView(ftNSUrl varchar2,
140 ftName varchar2,
141 viewTableList mdsys.StringList,
142 viewTablePkeyColList mdsys.StringList,
143 formattedViewTableColList mdsys.StringListList,
144 tablePKeyColList mdsys.StringList);
145 procedure unRegisterMTableView(ftNSUrl varchar2,
146 ftName varchar2);
147 function notInArray(p varchar2, pList mdsys.RowPointerList) return number;
148
149 function genSpatialArrInfo(tableNamePrefix varchar2, pkVal varchar2,
150 l_spatialArrList mdsys.StringListList,
151 data XMLType, srsNs varchar2, spatialArrUpdMap varchar2, ISGML3 varchar2, spArrPathsSRSNSList mdsys.StringListList)
152 return mdsys.SDO_GEOM_PATH_INFO_LIST;
153 function getUpdateMap(spatialArrList mdsys.StringListList) return varchar2;
154 function expandPath(aliasedPath varchar2, nsParam varchar2) return varchar2;
155 function findNSUrl(nsAlias varchar2, nsAliasList mdsys.StringList, nsUrlList mdsys.StringList) return varchar2;
156 function getCount(pathPattern varchar2, nsParam varchar2, data xmltype) return number;
157 function enumerateArrPaths(pathPattern varchar2, nsParam varchar2, data xmltype) return mdsys.StringList;
158 procedure genTriggers(tNS varchar2, tName varchar2);
159 function isListMember(featureTypeName varchar2, namespaceUrl varchar2, ftIdList mdsys.StringListList) return number;
160 PROCEDURE initialize_after_import;
161
162 FUNCTION prepare_for_export_user return varchar2;
163 FUNCTION prepare_for_export_user(exportSDOMetadata varchar2) return varchar2;
164
165 FUNCTION prepare_for_export_fts (ftList mdsys.StringListList) return varchar2;
166 FUNCTION prepare_for_export_fts (ftList mdsys.StringListList, exportSDOMetadata varchar2) return varchar2;
167 PROCEDURE prepare_for_export_ft_m_int(ftName in varchar2, ftNsUrl in varchar2, exportSDOMetadata varchar2) ;
168 PROCEDURE prepare_for_export_ft_int(ftName in varchar2, ftNsUrl in varchar2, exportSDOMetadata varchar2);
169
170 FUNCTION prepare_for_export_all return varchar2;
171 FUNCTION prepare_for_export_all(exportSDOMetadata varchar2) return varchar2;
172 procedure drop_export_tables;
173 procedure genUpdateStr(spatialColCount number, update_prefix varchar2, update_suffix varchar2);
174 procedure preProcessInsert (xmldata xmltype,
175 idPaths mdsys.StringList,
176 spatialPaths mdsys.StringList,
177 parsedAliasSpPath mdsys.StringListList,
178 spPathsSRSNSList mdsys.StringListList,
179 spatialArrPathsList mdsys.StringListList,
180 spArrPathsSRSNSList mdsys.StringListList,
181 ftNS varchar2,
182 ftName varchar2,
183 ftId number,
184 ftUserName varchar2,
185 tableName varchar2,
186 srsNs varchar2,
187 ISGML3 varchar2,
188 spatialPathsStgSrIds mdsys.sdoNumList, -- spatialPaths storage srid
189 spatialArrPathsStgSrIds mdsys.sdoNumList, pkColVal OUT VARCHAR2); -- spatial Arr paths storage srids
190 procedure preProcessUpdate(xmldata xmltype,
191 oldId varchar2,
192 spColUpdMap mdsys.StringList,
193 spArrColUpdMap mdsys.StringList,
194 idPaths mdsys.StringList,
195 spatialPaths mdsys.StringList,
196 parsedAliasSpPath mdsys.StringListList,
197 spPathsSRSNSList mdsys.StringListList,
198 spatialArrPathsList mdsys.StringListList,
199 spArrPathsSRSNSList mdsys.StringListList,
200 ftNS varchar2,
201 ftName varchar2,
202 ftId number,
203 ftUserName varchar2,
204 tableName varchar2,
205 srsNs varchar2,
206 ISGML3 varchar2,
207 spatialPathsStgSrIds mdsys.sdoNumList, -- spatialPaths storage srid
208 spatialArrPathsStgSrIds mdsys.sdoNumList, -- spatial Arr paths storage srids
209 computeSp number, newId OUT varchar2);
210
211 END SDO_WFS_PROCESS;