2.從其他Web Agent服務的OWA數據庫用戶的模式下刪除工具箱的PL/SQL包，假如 你已經安裝了這些包的話。 connect / drop package HTF; drop package HTP; drop package OWA_UTIL; drop package OWA; 3. 向其他Web Agent服務的OWA數據庫用戶授與在這些PL/SQL包上的EXECUTE權限。 connect / grant execute on HTF to ; grant execute on HTP to ; grant execute on OWA_UTIL to ; grant execute on OWA to ; 4. 在所有的OWA數據庫用戶中建立工具箱PL/SQL包的同義詞。 connect / create synonym HTF for .HTF; create synonym HTP for .HTP; create synonym OWA_UTIL for .OWA_UTIL; create synonym OWA for .OWA; Security Note 安全要點 PL/SQL 過程以PL/SQL代碼的創建者的權限運行。 對于Developer''s Toolkit, 這只關系到owa_util包. 兩個子程序, showsource和tableprint,存取用戶的數據。此包上的執行權限只能授給答應訪問owa_util擁有者的表，視圖和PL/SQL存儲代碼的擁護。
假如你的安裝要考慮安全問題，為每個OWA數據庫用戶安裝獨立的owa_util包。
作此事的腳本如下：
PUBUTIL.SQL PRIVUTIL.SQL 它們都在OWS治理目錄下，應按所列的順序執行。 List Tags 列表標記 List tags allow you to display information in any of the following ways:
ordered: these lists have numbered items unordered: these lists have bullets to mark each item definition: these lists alternate a term with its definition Note: All the hypertext procedures (HTP) shown in this section are also available as hypertext functions (HTF).
htp.listHeader 語法 htp.listHeader (ctext, cattributes); 作用 Prints an HTML tag at the beginning of the list 參數 ctext in varchar2 cattributes in varchar2 DEFAULT NULL Generates ctext
htp.listItem 語法 htp.listItem (ctext, cclear, cdingbat, csrc, cattributes); 作用 Prints an HTML tag that formats a listed item. 參數 ctext in varchar2 DEFAULT NULL cclear in varchar2 DEFAULT NULL cdingbat in varchar2 DEFAULT NULL csrc in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
ctext
htp.ulistOpen 語法 htp.ulistOpen (cclear, cwrap, cdingbat, csrc, cattributes); 作用 Prints an HTML tag that is used to open an unordered list that presents listed items separated by white space and marked off by bullets. 參數 cclear in varchar2 DEFAULT NULL cwrap in varchar2 DEFAULT NULL cdingbat in varchar2 DEFAULT NULL csrc in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
htp.ulistClose 語法 htp.ulistClose; 作用 Prints an HTML tag that ends the unordered list. 參數 none Generates
htp.olistOpen 語法 htp.olistOpen (cclear, cwrap, cattributes); 作用 Prints an HTML tag that is used to open an ordered list that presents listed items marked off with numbers. 參數 cclear in varchar2 DEFAULT NULL cwrap in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
htp.olistClose 語法 htp.olistClose; 作用 Prints an HTML tag that ends an ordered list. 參數 none Generates
htp.dlistOpen 語法 htp.dlistOpen (cclear, cattributes); 作用 Prints an HTML tag that starts a definition list 參數 cclear in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
htp.dlistClose 語法 htp.dlistClose 作用 Prints an HTML tag that Ends a definition list 參數 none Generates
作用 Prints an HTML tag that is used to insert terms, and their corresponding definitions in an indented list format. The htp.dlistTerm must immediately follow this tag. 參數 ctext in varchar2 DEFAULT NULL clear in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
ctext
htp.dlistTerm 語法 htp.dlistTerm (ctext, cclear, cattributes); 作用 Prints an HTML tag used to insert the definition term inside the definition list. This tag must immediately follow the htp.dlistDef. 參數 ctext in varchar2 DEFAULT NULL cclear in varchar2 DEFAULT NULL cattributes in varchar2 DEFAULT NULL Generates
ctext
htp.menulistOpen 語法 htp.menulistOpen; 作用 Prints an HTML tag that begins a list that presents one line per item, and appears more compact than an unordered list. The htp.listItem will follow this tag. 參數 none Generates
