📄 arpls.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Oracle9i Supplied PL/SQL Packages and Types"><TITLE> Oracle9i Supplied PL/SQL Packages and Types</TITLE> <LINK REL="home" HREF="../../products.htm" TITLE="Library"><LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../dcommon/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="adxdb.htm" TITLE="Next"><LINK REL="previous" HREF="strms.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><B>Oracle9<i>i</i> Database Generic Documentation Addendum<BR>Release 2 (9.2)</B><BR>Part Number A97283-01</FONT></B></TD><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE><HR><P><A HREF="strms.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A><A HREF="adxdb.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A> <DIV CLASS="IND"><!-- End Header --><A NAME="1004572"></A><!--TOC=Title-"1004572"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">11<BR> Oracle9<EM CLASS="Italic">i</EM> Supplied PL/SQL Packages and Types</FONT></H1><!--/TOC=Title--><A NAME="1004638"></A><P CLASS="BP">This chapter lists additions and corrections to <EM CLASS="Italic">Oracle9i Supplied PL/SQL Packages and Types Reference</EM>, Release 2 (9.2).</P><A NAME="1005351"></A><P CLASS="BP">This chapter contains the following topic:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1005352"></A><A HREF="arpls.htm#1004641">Documentation Corrections</a><P></UL><A NAME="1004641"></A><!--TOC=h1-"1004641"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Documentation Corrections</FONT></H2><!--/TOC=h1--><A NAME="1005381"></A><P CLASS="BP">The following are corrections to the <EM CLASS="Italic">Oracle9i Supplied PL/SQL Packages and Types Reference</EM> document:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="1004642"></A>In Chapter 14, "DBMS_DESCRIBE," Table 14-2, the description of the <CODE>length</CODE> parameter should read as follows: "For <CODE>%type</CODE> formal arguments, a length of <CODE>0</CODE> is returned." This is the result of a fix to bug 1402425.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="1005437"></A>In Chapter 29, "DBMS_LOGSTDBY," the order of the parameters for the <CODE>INSTANTIATE_TABLE</CODE> procedure is incorrect. The correct parameter order is as follows:<P> <PRE CLASS="CE"><A NAME="1005443"></A> DBMS_LOGSTDBY.INSTANTIATE_TABLE (<A NAME="1005444"></A> schema_name IN VARCHAR2,<A NAME="1005445"></A> table_name IN VARCHAR2,<A NAME="1005446"></A> dblink IN VARCHAR2);<A NAME="1005447"></A></PRE> <A NAME="1005448"></A><P CLASS="BP1">Also, the <CODE>DBMS_LOGSTDBY.INSTANTIATE_TABLE</CODE> procedure does not support the <CODE>BLOB</CODE> datatype even though <CODE>BLOB</CODE> datatypes are supported by logical standby databases.</P><LI CLASS="LB1" TYPE="DISC"><A NAME="1005442"></A>In Chapter 73, "DBMS_STREAMS_ADM," Table 73-10, the description of the <CODE>streams_type</CODE> parameter should read as follows: "The type of Streams rule, either <CODE>capture</CODE>, <CODE>apply</CODE>, or <CODE>propagation</CODE>."<P><LI CLASS="LB1" TYPE="DISC"><A NAME="1004765"></A>In Chapter 107, "JMS Types," the following constants should be listed under "Constants to Support the aq$_jms_message Type.":<P><UL><A NAME="1004771"></A><P CLASS="BP2"><CODE>JMS_TEXT_MESSAGE CONSTANT BINARY_INTEGER;</CODE></P><A NAME="1004772"></A><P CLASS="BP2"><CODE>JMS_BYTES_MESSAGE CONSTANT BINARY_INTEGER;</CODE></P> </UL><A NAME="1004760"></A><P CLASS="BP1">The following constants are not supported:</P><A NAME="1004586"></A><P CLASS="BP2"><CODE>JMS_STREAM_MESSAGE</CODE></P><A NAME="1004587"></A><P CLASS="BP2"><CODE>JMS_MAP_MESSAGE</CODE></P><A NAME="1004588"></A><P CLASS="BP2"><CODE>JMS_OBJECT_MESSAGE</CODE></P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1004791"></A>In Chapter 107, "JMS Types," the first sentence under "aq$_jms_message Type" should read as follows: "This type is the ADT used to store <CODE>JMSText</CODE> and <CODE>JMSBytes</CODE> message types." The <CODE>JMSMap</CODE>, <CODE>JMSStream</CODE>, and <CODE>JMSObject</CODE> types should not be included.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="1004844"></A>In Chapter 107, "JMS Types," the syntax for the member procedures and functions incorrectly prepends <CODE>DBMS_AQJMS</CODE>. The syntax should read as follows:<P> <PRE CLASS="CE"><A NAME="1004861"></A> LOOKUP_PROPERTY_NAME(<A NAME="1004862"></A> new_property_name IN VARCHAR);<A NAME="1004853"></A><A NAME="1004867"></A> SET_REPLYTO(<A NAME="1004868"></A> replyto IN SYS.AQ$_AGENT);<A NAME="1004865"></A><A NAME="1004873"></A> SET_TYPE(<A NAME="1004874"></A> type IN VARCHAR);<A NAME="1004871"></A><A NAME="1004879"></A> SET_USERID(<A NAME="1004880"></A> userid IN VARCHAR);<A NAME="1004877"></A><A NAME="1004885"></A> SET_APPID(<A NAME="1004886"></A> appid IN VARCHAR);<A NAME="1004883"></A><A NAME="1004891"></A> SET_GROUPID(<A NAME="1004892"></A> groupid IN VARCHAR);<A NAME="1004889"></A><A NAME="1004897"></A> SET_GROUPSEQ(<A NAME="1004898"></A> groupseq IN INT);<A NAME="1004895"></A><A NAME="1004903"></A> CLEAR_PROPERTIES;<A NAME="1004901"></A><A NAME="1004921"></A> SET_BOOLEAN_PROPERTY(<A NAME="1004922"></A> property_name IN VARCHAR,<A NAME="1004923"></A> property_value IN BOOLEAN);<A NAME="1004906"></A><A NAME="1004927"></A> SET_BYTE_PROPERTY(<A NAME="1004928"></A> property_name IN VARCHAR,<A NAME="1004929"></A> property_value IN INT);<A NAME="1004919"></A><A NAME="1004934"></A> SET_SHORT_PROPERTY(<A NAME="1004935"></A> property_name IN VARCHAR,<A NAME="1004936"></A> property_value IN INT);<A NAME="1004932"></A><A NAME="1004941"></A> SET_INT_PROPERTY(<A NAME="1004942"></A> property_name IN VARCHAR,<A NAME="1004943"></A> property_value IN INT);<A NAME="1004939"></A><A NAME="1004948"></A> SET_LONG_PROPERTY(<A NAME="1004949"></A> property_name IN VARCHAR,<A NAME="1004950"></A> property_value IN NUMBER);<A NAME="1004946"></A><A NAME="1004955"></A> SET_FLOAT_PROPERTY(<A NAME="1004956"></A> property_name IN VARCHAR,<A NAME="1004957"></A> property_value IN FLOAT);<A NAME="1004953"></A><A NAME="1004962"></A> SET_DOUBLE_PROPERTY(<A NAME="1004963"></A> property_name IN VARCHAR,<A NAME="1004964"></A> property_value IN DOUBLE PRECISION);<A NAME="1004960"></A><A NAME="1004969"></A> SET_STRING_PROPERTY(<A NAME="1004970"></A> property_name IN VARCHAR,<A NAME="1004971"></A> property_value IN VARDHAR);<A NAME="1004967"></A><A NAME="1005037"></A> GET_REPLYTO(<A NAME="1005038"></A> replyto OUT SYS.AQ$_AGENT);<A NAME="1005039"></A><A NAME="1005040"></A> GET_TYPE(<A NAME="1005041"></A> type OUT VARCHAR);<A NAME="1005042"></A><A NAME="1005043"></A> GET_USERID(<A NAME="1005044"></A> userid OUT VARCHAR);<A NAME="1005045"></A><A NAME="1005046"></A> GET_APPID(<A NAME="1005047"></A> appid OUT VARCHAR);<A NAME="1005048"></A><A NAME="1005049"></A> GET_GROUPID(<A NAME="1005050"></A> groupid OUT VARCHAR);<A NAME="1005051"></A><A NAME="1005052"></A> GET_GROUPSEQ(<A NAME="1005053"></A> groupseq OUT INT);<A NAME="1005054"></A><A NAME="1005055"></A> GET_BOOLEAN_PROPERTY(<A NAME="1005056"></A> property_name IN VARCHAR)<A NAME="1005057"></A> RETURN BOOLEAN;<A NAME="1004612"></A><A NAME="1005065"></A> GET_BYTE_PROPERTY(<A NAME="1005066"></A> property_name IN VARCHAR)<A NAME="1005067"></A> RETURN INT;<A NAME="1005062"></A><A NAME="1005072"></A> GET_SHORT_PROPERTY(<A NAME="1005073"></A> property_name IN VARCHAR)<A NAME="1005074"></A> RETURN INT;<A NAME="1005070"></A><A NAME="1005079"></A> GET_INT_PROPERTY(<A NAME="1005080"></A> property_name IN VARCHAR)<A NAME="1005081"></A> RETURN INT;<A NAME="1005077"></A><A NAME="1005085"></A> GET_LONG_PROPERTY(<A NAME="1005086"></A> property_name IN VARCHAR)<A NAME="1005087"></A> RETURN NUMBER;<A NAME="1005063"></A><A NAME="1005092"></A> GET_FLOAT_PROPERTY(<A NAME="1005093"></A> property_name IN VARCHAR)<A NAME="1005094"></A> RETURN FLOAT;<A NAME="1005090"></A><A NAME="1005099"></A> GET_DOUBLE_PROPERTY(<A NAME="1005100"></A> property_name IN VARCHAR)<A NAME="1005101"></A> RETURN DOUBLE PRECISION;<A NAME="1005097"></A><A NAME="1005106"></A> GET_STRING_PROPERTY(<A NAME="1005107"></A> property_name IN VARCHAR)<A NAME="1005108"></A> RETURN VARCHAR;<A NAME="1005104"></A><A NAME="1005113"></A> CONSTRUCT(<A NAME="1005114"></A> mtype IN INT)<A NAME="1005115"></A> RETURN aq$_jms_message;<A NAME="1005111"></A><A NAME="1005120"></A> CONSTRUCT RETURN aq$_jms_text_message;<A NAME="1005118"></A><A NAME="1005125"></A> SET_TEXT(<A NAME="1005126"></A> payload IN VARCHAR2);<A NAME="1005123"></A><A NAME="1005131"></A> SET_TEXT(<A NAME="1005132"></A> payload IN CLOB);<A NAME="1005129"></A><A NAME="1005137"></A> GET_TEXT(<A NAME="1005138"></A> payload OUT VARCHAR2);<A NAME="1005135"></A><A NAME="1005150"></A> GET_TEXT(<A NAME="1005151"></A> payload OUT CLOB);<A NAME="1005141"></A><A NAME="1005165"></A> SET_BYTES(<A NAME="1005166"></A> payload IN RAW);<A NAME="1005154"></A><A NAME="1005174"></A> SET_BYTES(<A NAME="1005175"></A> payload IN BLOB);<A NAME="1005169"></A><A NAME="1005180"></A> GET_BYTES(<A NAME="1005181"></A> payload OUT RAW);<A NAME="1005178"></A><A NAME="1005186"></A> GET_BYTES(<A NAME="1005187"></A> payload OUT BLOB);</PRE> <A NAME="1005170"></A><P CLASS="BP2"></P> </UL><!-- Start Footer --></DIV><DIV CLASS="OUTD"><HR><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR><TD VALIGN="BOTTOM" WIDTH="33%"><TABLE CELLSPACING="0" CELLPADDING="0"><TR><TD ALIGN="CENTER"><A HREF="strms.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD><TD ALIGN="CENTER"><A HREF="adxdb.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD> </TR></TABLE></TD><TD ALIGN="CENTER" WIDTH="34%"><font size="-2">Copyright © 2002 Oracle Corporation.</font><BR><FONT SIZE="-2">All Rights Reserved.</FONT></TD><TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="33%"> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="144"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="conticon.gif" ALT="Go To Table Of Contents" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Contents</FONT></A></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="index.htm"><IMG SRC="indxicon.gif" ALT="Go To Index" BORDER="0" HEIGHT="30"WIDTH="30"><BR><FONT SIZE="-2">Index</FONT></A></TD></TR></TABLE></TD></TR></TABLE> </DIV></BODY></HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -