默认情况，这个ftp的端口是关闭的，可以通过下面的命令打开：
SQL> conn / as sysdba已连接。
| SQL> @?/rdbms/admin/catxdbdbca.sql 7788 8800 SQL> SET FEEDBACK 1 SQL> SET NUMWIDTH 10 SQL> SET LINESIZE 80 SQL> SET TRIMSPOOL ON SQL> SET TAB OFF SQL> SET PAGESIZE 100 SQL> SQL> define ftpport = &1 SQL> define httpport = &2 SQL> Rem Create a function to traverse the dom elements. SQL> CREATE OR REPLACE FUNCTION traverseDom 2 (parnode dbms_xmldom.DOMNode, pathSeg VARCHAR2) 3 RETURN dbms_xmldom.DOMNode IS 4 nodeList dbms_xmldom.DOMNodeList; 5 anElement dbms_xmldom.DOMElement; 6 aNode dbms_xmldom.DOMNode; 7 BEGIN 8 -- Convert the passed in dom node to an element 9 anElement := dbms_xmldom.makeElement(parnode); 10 11 -- Select the path segment requested by the user 12 nodeList := dbms_xmldom.getChildrenByTagName(anElement, pathSeg); 13 14 -- get the first node out of the list 15 aNode := dbms_xmldom.item(nodeList, 0); 16 17 -- return that node (ignore errors here). 18 return aNode; 19 END; 20 / |
函数已创建。
| SQL> SQL> declare 2 configxml sys.xmltype; 3 configdomdoc dbms_xmldom.DOMDocument; 4 textNode dbms_xmldom.DOMNode; 5 aNode dbms_xmldom.DOMNode; 6 protNode dbms_xmldom.DOMNode; 7 anElement dbms_xmldom.DOMElement; 8 listOfNodes dbms_xmldom.DOMNodeList; 9 aString VARCHAR2(100); 10 begin 11 12 -- Select the resource and set it into the config 13 select sys_nc_rowinfo$ into configxml from xdb.xdb$config ; 14 |
