ADD_PRIORITY_ datatype Procedure</titl e> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <meta h ttp-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="robo ts" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Database Advanced Replication Manage ment API Reference 10g Release 1 (10.1)"> <meta name="partno" content="B10733-01"> <link rel="Start" href="../../index.htm" title="Ho me" type="text/html"> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html"> <link rel="Stylesh eet" href="../../dcommon/css/doccd.css" title="Default" type="text/css"> <link rel="Contents" href="toc.htm" title="Contents" type="t ext/html"> <link rel="Index" href="index.htm" title="Index" type="text/html"> <link rel="Prev" href="rarrcat4.htm" title="Previous" t ype="text/html"> <link rel="Up" href="rarrcatp.htm" title="Up" type="text/html"> <link rel="Next" href="rarrcat6.htm" title="Next" ty pe="text/html"> <link rel="alternate" href="../b10733.pdf" title="PDF version" type="application/pdf"> </head> <body> <div class="hea der"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <t r> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif"><strong>Oracle® Database Advanced Repl ication Management API Reference<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10733-01</font></td> <td valign="bottom" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../ind ex.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></td > <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" b order="0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gi fs/conticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="to p"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">Index</font></a>< /td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master I ndex" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html/f eedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a> </td></tr></table></td></tr></table> <hr> <table summary="layout table" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align= "left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a href="rarrcat4.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2 ">Previous</font></a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon/gifs/uarrow.gif" alt="Go to current chapter" border="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrcat6.htm"><img src= "../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td alig n="right" valign="top"><a href="../b10733.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN"></a></div> <div class="IND"> <a name="102195"></a> <h2 class="CM2"><font face="Arial, Helvetica, sans-serif" color="#330099">ADD_ PRIORITY_<em class="Italic">datatype</em> Procedure</font></h2> <a name="101332"></a> <p class="BP">This procedure adds a member to a priority group. You must call this procedure from the master definition site. The procedure that you must call is determined by the datatype of your <code>priority</code> column. You must call this procedure once for each of the possible values of the <code>priori ty</code> column.</p> <a name="94619"></a> <div align="center"> <table class="NoteAlso" border="0" width="80%" cellpadding="0" cells pacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="No teAlso"> <td class="NoteAlso"><a name="94612"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">See Also:</strong></fo nt> <a name="94618"></a> <p class="NB"><a href="rarconfl.htm#21415">Chapter 6, "Configure Conflict Resolution"</a> and <em clas s="Italic"><a class="xlinkSRC REPLN005" href="../../server$101/b10732/repconfl.htm#REPLN005">Oracle Database Advanced Replication</a> </em> for more information about conflict resolution methods</p></td></tr></table></div> <a name="94620"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Syntax</font></h3> <pre class="CE"><a name="94621"></a>DBMS_REPCAT.ADD_PRIORITY_< em class="Italic">datatype</em> ( <a name="94622"></a> gname IN VARCHAR2, <a name="94623"></a> pgroup IN VARCHAR2, <a name="94624"></a> value IN <em class="Italic">datatype</em>, <a name="94625"></a> priority IN NUMBER); <a name="94626"></a> </pre> <a name="94627"></a> <p class="BP">where <em class="Italic">datatype</em>:</p> <pr e class="CE"><a name="94628"></a>{ NUMBER <a name="94629"></a>| VARCHAR2 <a name="94630"></a>| CHAR <a name="94631"></a>| DATE <a nam e="94632"></a>| RAW <a name="94633"></a>| NCHAR <a name="94634"></a>| NVARCHAR2 } </pre> <a name="94635"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330099">Parameters</font></h3> <h5 class="TT"><a name="94662"></a><a name="94639"></a> <s trong><font face="Arial, Helvetica, sans-serif"><em>Table 18-8 ADD_PRIORITY_<em class="Italic">datatype Procedure Parameters </ em></em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name=" 94643"></a> <font face="Arial, Helvetica, sans-serif"><strong>Parameter</strong></font></th> <th class="Formal" align="left" valign=" bottom" scope="col"><a name="94645"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></the ad> <tbody> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94647"></a>gname </pre> </td> <td class="Formal"><a name="94649"></a> <p class="TB">Master group for which you are creating a priority group.</p></td></tr> <tr cl ass="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94651"></a>pgroup </pre> </td> <td class="Forma l"><a name="94653"></a> <p class="TB">Name of the priority group.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cla ss="Formal"> <pre class="CEW"><a name="94655"></a>value </pre> </td> <td class="Formal"><a name="94657"></a> <p class="TB">Value of t he priority group member. This is one of the possible values of the associated <code>priority</code> column of a table using this pri ority group.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94659"></a>pri ority </pre> </td> <td class="Formal"><a name="94661"></a> <p class="TB">Priority of this value. The higher the number, the higher th e priority.</p></td></tr></tbody></table> <a name="94663"></a> <h3 class="CMS"><font face="Arial, Helvetica, sans-serif" color="#330 099">Exceptions</font></h3> <h5 class="TT"><a name="94702"></a><a name="94667"></a> <strong><font face="Arial, Helvetica, sans-serif" ><em>Table 18-9 ADD_PRIORITY_<em class="Italic">datatype Procedure Exceptions </em></em></font></strong></h5> <table summary="" class="Formal" border="1" frame="HSIDES" rules="GROUPS" width="100%" cellpadding="3" cellspacing="0" dir="ltr" title=""> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="94671"></a> <font face="Arial, Helvetica, sans- serif"><strong>Exception</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="94673"></a> <font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font></th></tr></thead> <tbody> <tr class="Formal" align="left" val ign="top"> <td class="Formal"> <pre class="CEW"><a name="94675"></a>nonmasterdef </pre> </td> <td class="Formal"><a name="94677"></a> <p class="TB">Invocation site is not the master definition site.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td cla ss="Formal"> <pre class="CEW"><a name="94679"></a>duplicatevalue </pre> </td> <td class="Formal"><a name="94681"></a> <p class="TB">S pecified value already exists in the priority group.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94683"></a>duplicatepriority </pre> </td> <td class="Formal"><a name="94685"></a> <p class="TB">Specified p riority already exists in the priority group.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre cl ass="CEW"><a name="94687"></a>missingrepgroup </pre> </td> <td class="Formal"><a name="94689"></a> <p class="TB">Specified master gro up does not exist.</p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94691">< /a>missingprioritygroup </pre> </td> <td class="Formal"><a name="94693"></a> <p class="TB">Specified priority group does not exist.</ p></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94695"></a>typefailure </pre > </td> <td class="Formal"><a name="94697"></a> <p class="TB">Specified value has the incorrect datatype for the priority group.</p>< /td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"> <pre class="CEW"><a name="94699"></a>notquiesced </pre> < /td> <td class="Formal"><a name="94701"></a> <p class="TB">Specified master group is not quiesced.</p></td></tr></tbody></table></div > <div class="footer"> <hr> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left" > <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="135"> <tr> <td align="center" valign="top"><a hre f="rarrcat4.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0"><br> <font size="-2">Previous</font></ a></td> <td align="center" valign="top"><a href="rarrcatp.htm"><img src="../../dcommon/gifs/uarrow.gif" alt="Go to current chapter" b order="0"><br> <font size="-2">Up</font></a></td> <td align="center" valign="top"><a href="rarrcat6.htm"><img src="../../dcommon/gifs /rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></table></td> <td style="width: 34%;" ali gn="center"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle"><br> <a href="../../dcommon/html/cpyr.htm"><font size="-2">Copyrigh t © 1996, 2003 Oracle Corporation</font></a><br> <font size="-2">All Rights Reserved.</font></td> <td style="width: 33%;" align= "right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href="../../index.htm "><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0"><br> <font size="-2">Home</font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" border= "0"><br> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gifs/con ticon.gif" alt="Go to Table of Contents" border="0"><br> <font size="-2">Contents</font></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0"><br> <font size="-2">Index</font></a></td> < td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</font></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedbac k.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0"><br> <font size="-2">Feedback</font></a></td>< /tr></table></td></tr></table></div> </body> </html>