Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\query\help.sql
begin declare clob_loc clob; buf raw(32767); begin --WM Text Documents of type .html --text document 'us/about.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('about.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'about.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 47, '<title>About Warehouse Builder Browser</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 71, '<p><font face="Arial Black">About Warehouse Builder Browser</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">Displays information about the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 58, 'Browser such as the Build and Version numbers.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 49, '<p><font face="Arial" size="2"> </font></p> '); dbms_lob.close(clob_loc); --text document 'us/admn_crt_dblnk.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_crt_dblnk.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_crt_dblnk.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 39, '<title>Creating Database Links</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font face="Arial Black">Creating Database Links</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 16, '<font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 76, '<p><font size="2" face="Arial"><b>To create a database link:</b></font></p> '); dbms_lob.writeappend(clob_loc, 13, '<blockquote> '); dbms_lob.writeappend(clob_loc, 91, ' <p><font size="2" face="Arial">1. Select <u>Create Database Link</u> from the Administer '); dbms_lob.writeappend(clob_loc, 79, ' Database Links page which is linkable from the Register Repository page.<br> '); dbms_lob.writeappend(clob_loc, 41, ' 2. Specify the database link name.<br> '); dbms_lob.writeappend(clob_loc, 46, ' 3. Specify the OWB repository user name and '); dbms_lob.writeappend(clob_loc, 16, ' password.<br> '); dbms_lob.writeappend(clob_loc, 98, ' </font></font><font size="2" face="Arial">4. Specify the remote database information. <br> '); dbms_lob.writeappend(clob_loc, 47, ' You have two options:<br> '); dbms_lob.writeappend(clob_loc, 80, ' </font> * <font size="2" face="Arial">Enter the '); dbms_lob.writeappend(clob_loc, 36, ' TNS name for the database, or<br> '); dbms_lob.writeappend(clob_loc, 80, ' </font> * <font size="2" face="Arial">Enter the '); dbms_lob.writeappend(clob_loc, 65, ' host address, service name, protocol and host port number.<br> '); dbms_lob.writeappend(clob_loc, 55, ' 5. Click <b>Apply</b> to connect the link. <br> '); dbms_lob.writeappend(clob_loc, 35, ' 6. Click <b> OK</b> when you are '); dbms_lob.writeappend(clob_loc, 16, ' finished.<br> '); dbms_lob.writeappend(clob_loc, 76, ' The new link displays on the Administer Database Links '); dbms_lob.writeappend(clob_loc, 19, ' page.</font></p> '); dbms_lob.writeappend(clob_loc, 14, '</blockquote> '); dbms_lob.writeappend(clob_loc, 18, ' <font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 7, ' <hr> '); dbms_lob.writeappend(clob_loc, 8, '</font> '); dbms_lob.close(clob_loc); --text document 'us/admn_dblnk.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_dblnk.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_dblnk.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 44, '<title>Administering Database Links</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 77, '<p><font size="3" face="Arial Black">Administering Database Links</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 65, '<p><font size="2" face="Arial">Use the Administer Database Links '); dbms_lob.writeappend(clob_loc, 65, 'page to edit, drop, or view information about database links. If '); dbms_lob.writeappend(clob_loc, 52, 'you need to create database links, select </font><a '); dbms_lob.writeappend(clob_loc, 66, 'href="@admn_crt_dblnk.html"><font size="2" face="Arial"><u>Create '); dbms_lob.writeappend(clob_loc, 66, 'Database Link</u></font></a><font size="2" face="Arial">. To edit '); dbms_lob.writeappend(clob_loc, 62, 'a database link, select <u>edit</u> and use the Edit Database '); dbms_lob.writeappend(clob_loc, 47, 'Link page. For more information, see </font><a '); dbms_lob.writeappend(clob_loc, 68, 'href="@rsrcmgnt_ed_dblink.html"><font size="2" face="Arial">Editing '); dbms_lob.writeappend(clob_loc, 67, 'a Database Link</font></a><font size="2" face="Arial">.</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<p><font size="2" face="Arial"><b>To view information about '); dbms_lob.writeappend(clob_loc, 31, 'database links:</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<ol> '); dbms_lob.writeappend(clob_loc, 59, ' <li><font size="2" face="Arial">Select the name of the '); dbms_lob.writeappend(clob_loc, 67, ' database link from the Administer Database Links page.<br> '); dbms_lob.writeappend(clob_loc, 61, ' The View Database Link page displays with a detailed '); dbms_lob.writeappend(clob_loc, 62, ' report on the database link you selected.</font></li> '); dbms_lob.writeappend(clob_loc, 58, ' <li><font size="2" face="Arial">Click OK when you are '); dbms_lob.writeappend(clob_loc, 22, ' finished.<br> '); dbms_lob.writeappend(clob_loc, 66, ' The browser will take you back to the Administer Database '); dbms_lob.writeappend(clob_loc, 32, ' Links page.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ol> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 13, '<blockquote> '); dbms_lob.writeappend(clob_loc, 66, ' <p><font size="2" face="Arial"><b>NOTE: </b>The View Database '); dbms_lob.writeappend(clob_loc, 64, ' Link page does not allow you to edit the link. Use the Edit '); dbms_lob.writeappend(clob_loc, 75, ' Database Link page to make changes and updates to the link.</font></p> '); dbms_lob.writeappend(clob_loc, 14, '</blockquote> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, '<p><font size="2" face="Arial"><b>To drop a database link:</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<ol> '); dbms_lob.writeappend(clob_loc, 65, ' <li><font size="2" face="Arial">From the Administer Database '); dbms_lob.writeappend(clob_loc, 63, ' Links page, select the <u>drop</u> action link for the '); dbms_lob.writeappend(clob_loc, 64, ' database link you want to drop. The <u>drop</u> link is '); dbms_lob.writeappend(clob_loc, 54, ' located under the Actions column.</font></li> '); dbms_lob.writeappend(clob_loc, 65, ' <li><font size="2" face="Arial">The database link is dropped '); dbms_lob.writeappend(clob_loc, 62, ' and you are returned to the Administer Database Links '); dbms_lob.writeappend(clob_loc, 47, ' page. You cannot undo this action.<br> '); dbms_lob.writeappend(clob_loc, 55, ' If the database link has been used to register '); dbms_lob.writeappend(clob_loc, 69, ' repositories, unregister the repositories first.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ol> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 13, '<blockquote> '); dbms_lob.writeappend(clob_loc, 64, ' <p><font size="2" face="Arial"><b>NOTE:</b> Once you drop a '); dbms_lob.writeappend(clob_loc, 65, ' database link it is permanently destroyed. You must recreate '); dbms_lob.writeappend(clob_loc, 53, ' the link if you want to use it again.</font></p> '); dbms_lob.writeappend(clob_loc, 14, '</blockquote> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/admn_ldprf.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_ldprf.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_ldprf.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 35, '<title>Loading Preferences</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<p><font face="Arial Black">Loading Preferences</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">Use the Load Preferences page to load preferences '); dbms_lob.writeappend(clob_loc, 88, 'directly into an upgraded Warehouse Builder Browser from an existing Schema.</font></p> '); dbms_lob.writeappend(clob_loc, 87, '<p><font face="Arial" size="2">To load preferences from an existing schema:</font></p> '); dbms_lob.writeappend(clob_loc, 13, '<blockquote> '); dbms_lob.writeappend(clob_loc, 39, '<p><font face="Arial" size="2">1. Type '); dbms_lob.writeappend(clob_loc, 41, 'in the following information:</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 58, ' <li><font face="Arial" size="2">Schema Name</font></li> '); dbms_lob.writeappend(clob_loc, 62, ' <li><font face="Arial" size="2">Schema Password</font></li> '); dbms_lob.writeappend(clob_loc, 55, ' <li><font face="Arial" size="2">Hostname</font></li> '); dbms_lob.writeappend(clob_loc, 63, ' <li><font face="Arial" size="2">Host Port Number</font></li> '); dbms_lob.writeappend(clob_loc, 59, ' <li><font face="Arial" size="2">Database SID</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 88, ' <p><font face="Arial" size="2">2. Click <b>OK</b> to load the preferences.</font></p> '); dbms_lob.writeappend(clob_loc, 14, '</blockquote> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/admn_main.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_main.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_main.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 48, '<title>Warehouse Builder Administration</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 72, '<p><font face="Arial Black">Warehouse Builder Administration</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 57, '<p><font size="2" face="Arial">Use the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 64, 'Administration page to access the Administration functions. The '); dbms_lob.writeappend(clob_loc, 66, 'Administration functions can only be accessed if the current user '); dbms_lob.writeappend(clob_loc, 47, 'has Full Administrator privileges.</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 61, '<p><font size="2" face="Arial">Click the following links for '); dbms_lob.writeappend(clob_loc, 56, 'specific information about these functions:</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 74, ' <li><a href="@admn_reg_rep.html"><font size="2" face="Arial">Register '); dbms_lob.writeappend(clob_loc, 42, ' an OWB Repository</font></a></li> '); dbms_lob.writeappend(clob_loc, 74, ' <li><a href="@admn_reg_rpt.html"><font size="2" face="Arial">Register '); dbms_lob.writeappend(clob_loc, 40, ' a Custom Report</font></a></li> '); dbms_lob.writeappend(clob_loc, 67, ' <li><a href="@admn_prg.html"><font size="2" face="Arial">Purge '); dbms_lob.writeappend(clob_loc, 47, ' Stale User Information</font></a></li> '); dbms_lob.writeappend(clob_loc, 70, ' <li><a href="@rsrcmgmt.html"><font size="2" face="Arial">Resource '); dbms_lob.writeappend(clob_loc, 35, ' Management</font></a></li> '); dbms_lob.writeappend(clob_loc, 72, ' <li><a href="@admn_mng_prf.html"><font size="2" face="Arial">Manage '); dbms_lob.writeappend(clob_loc, 36, ' Preferences</font></a></li> '); dbms_lob.writeappend(clob_loc, 71, ' <li><a href="@admn_mng_di.html"><font size="2" face="Arial">Manage '); dbms_lob.writeappend(clob_loc, 41, ' Dependency Index</font></a></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 66, '<p><font size="2" face="Arial">The following table describes some '); dbms_lob.writeappend(clob_loc, 58, 'of the action links available on this portlet.</font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 47, '<table border="1" cellspacing="1" width="515"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 75, ' <td valign="top" width="155"><font size="2" face="Arial"><b>Action '); dbms_lob.writeappend(clob_loc, 29, ' Link</b></font></td> '); dbms_lob.writeappend(clob_loc, 96, ' <td valign="top" width="344"><font size="2" face="Arial"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 82, ' <td valign="top" width="155"><font size="2" face="Arial">Help</font></td> '); dbms_lob.writeappend(clob_loc, 74, ' <td valign="top" width="344"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 83, ' <td valign="top" width="155"><font size="2" face="Arial">About</font></td> '); dbms_lob.writeappend(clob_loc, 74, ' <td valign="top" width="344"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 70, ' <td valign="top" width="155"><font size="2" face="Arial">Full '); dbms_lob.writeappend(clob_loc, 25, ' Page</font></td> '); dbms_lob.writeappend(clob_loc, 74, ' <td valign="top" width="344"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 15, '<p> </p> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/admn_mng_di.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_mng_di.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_mng_di.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 45, '<title>Managing the Dependency Index</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial Black" size="3">Managing the Dependency Index</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 78, '<p><font class="PortletText2" size="2" face="Arial">Use the Manage Dependency '); dbms_lob.writeappend(clob_loc, 105, 'Index page to specify when to refresh the Dependency Index. The Dependency Index is used when displaying '); dbms_lob.writeappend(clob_loc, 79, 'Lineage and Impact Analysis diagrams. In order for the diagrams to display the '); dbms_lob.writeappend(clob_loc, 79, 'most current information, the index must be synchronized regularly.</font></p> '); dbms_lob.writeappend(clob_loc, 76, '<p><font class="PortletText2" size="2" face="Arial">Choose dependency index '); dbms_lob.writeappend(clob_loc, 87, 'refresh frequency by choosing one of the options below for each repository.</font></p> '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 100, ' <td width="26%" valign="top" align="left"><b><font face="Arial" size="2">Option</font></b></td> '); dbms_lob.writeappend(clob_loc, 105, ' <td width="74%" valign="top" align="left"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 126, ' <td width="26%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">Refresh on demand </font></td> '); dbms_lob.writeappend(clob_loc, 100, ' <td width="74%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">With '); dbms_lob.writeappend(clob_loc, 52, ' this option, you must activate the <u>refresh '); dbms_lob.writeappend(clob_loc, 77, 'dependency index</u> link to refresh the index. The refresh dependency index '); dbms_lob.writeappend(clob_loc, 55, ' link is located on Navigator page that lists all '); dbms_lob.writeappend(clob_loc, 81, ' accessible repositories. The dependency index will not be refreshed unless '); dbms_lob.writeappend(clob_loc, 44, ' this action link is activated.</font> '); dbms_lob.writeappend(clob_loc, 75, ' <p><font class="PortletText2" size="2" face="Arial">This is the best '); dbms_lob.writeappend(clob_loc, 75, ' option when using a repository that changes infrequently.</font></p> '); dbms_lob.writeappend(clob_loc, 10, ' </td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 135, ' <td width="26%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">Refresh on first diagram request of the '); dbms_lob.writeappend(clob_loc, 26, ' session</font></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="74%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">This option '); dbms_lob.writeappend(clob_loc, 93, ' refreshes the dependency index when the first Lineage or Impact Analysis diagram for a '); dbms_lob.writeappend(clob_loc, 43, 'repository is run during a session.</font> '); dbms_lob.writeappend(clob_loc, 75, ' <p><font class="PortletText2" size="2" face="Arial">This is the best '); dbms_lob.writeappend(clob_loc, 81, ' option if you want current information, but are not concerned with updates '); dbms_lob.writeappend(clob_loc, 48, ' that occur during the session.</font></p> '); dbms_lob.writeappend(clob_loc, 10, ' </td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 120, ' <td width="26%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">Refresh on every diagram '); dbms_lob.writeappend(clob_loc, 27, ' request </font></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="74%" valign="top" align="left"><font class="PortletText2" size="2" face="Arial">This option '); dbms_lob.writeappend(clob_loc, 43, ' refreshes the dependency index every '); dbms_lob.writeappend(clob_loc, 63, 'time a Lineage or Impact Analysis diagram is requested.</font> '); dbms_lob.writeappend(clob_loc, 75, ' <p><font class="PortletText2" size="2" face="Arial">This is the best '); dbms_lob.writeappend(clob_loc, 78, ' option if you want to display your diagrams and reports with the latest '); dbms_lob.writeappend(clob_loc, 48, ' information in the repository.</font></p> '); dbms_lob.writeappend(clob_loc, 10, ' </td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.close(clob_loc); --text document 'us/admn_mng_prf.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_mng_prf.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_mng_prf.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 36, '<title>Managing Preferences</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<p><font face="Arial Black">Managing Preferences</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 221, '<p><font face="Arial" size="2">Use the Manage Preferences page to save and load Warehouse Builder Browser preferences. This lets you retain your preferences when you upgrade to a new version of Warehouse Builder Browser. '); dbms_lob.writeappend(clob_loc, 92, 'Using the save and load features, you can copy schema preferences across schemas. <br> '); dbms_lob.writeappend(clob_loc, 49, 'The preferences you can save include:</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 56, ' <li><font face="Arial" size="2">Favorites</font></li> '); dbms_lob.writeappend(clob_loc, 72, ' <li><font face="Arial" size="2">Registered Custom Reports</font></li> '); dbms_lob.writeappend(clob_loc, 88, ' <li><font face="Arial" size="2">Registered Warehouse Builder Repositories</font></li> '); dbms_lob.writeappend(clob_loc, 71, ' <li><font face="Arial" size="2">Access rights associated with Roles, '); dbms_lob.writeappend(clob_loc, 71, ' Repositories, Custom Reports, and the Launcher Portlet</font></li> '); dbms_lob.writeappend(clob_loc, 61, ' <li><font face="Arial" size="2">External Links</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 68, '<p><font face="Arial" size="2"><b>Saving Preferences</b></font></p> '); dbms_lob.writeappend(clob_loc, 73, '<p><font face="Arial" size="2">To save preferences to a file:</font></p> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">1. Select <b>Save Preferences</b> from the Manage '); dbms_lob.writeappend(clob_loc, 29, 'Preferences page.</font></p> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">The preferences display in a separate window in a '); dbms_lob.writeappend(clob_loc, 34, 'condensed text format.</font></p> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">2. From the browser menu bar, select <b>File,</b> '); dbms_lob.writeappend(clob_loc, 53, 'and then <b>Save As</b> to save the file.</font></p> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2">This file can be loaded into Warehouse Builder '); dbms_lob.writeappend(clob_loc, 36, 'Browser using SQL* Plus.</font></p> '); dbms_lob.writeappend(clob_loc, 69, '<p><b><font face="Arial" size="2">Loading Preferences</font></b></p> '); dbms_lob.writeappend(clob_loc, 50, '<p><font face="Arial" size="2"> Click the <u>Load '); dbms_lob.writeappend(clob_loc, 33, 'Preferences</u> link to load the '); dbms_lob.writeappend(clob_loc, 81, 'preferences directly into an upgraded Warehouse Builder Browser from an existing '); dbms_lob.writeappend(clob_loc, 20, 'Schema. </font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.close(clob_loc); --text document 'us/admn_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 56, '<title>Warehouse Builder Administration Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 82, '<font face="Arial Black" size="3">Warehouse Builder Administration Portlet</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 87, '<p><font face="Arial" size="2">The Warehouse Builder Administration Portlet allows you '); dbms_lob.writeappend(clob_loc, 71, 'to access the Administration features directly from your Oracle Portal '); dbms_lob.writeappend(clob_loc, 57, 'home page. Select from the following options:</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 115, ' <li><b><font face="Arial" size="2">Register an OWB Repository</font></b><font face="Arial" size="2">- allows you '); dbms_lob.writeappend(clob_loc, 88, ' to register Warehouse Builder repositories and maintain database links.</font></li> '); dbms_lob.writeappend(clob_loc, 116, ' <li><b><font face="Arial" size="2">Register a Custom Report</font></b><font face="Arial" size="2">- allows you to '); dbms_lob.writeappend(clob_loc, 41, ' register custom reports.</font></li> '); dbms_lob.writeappend(clob_loc, 113, ' <li><b><font face="Arial" size="2">Purge Stale User Information</font></b><font face="Arial" size="2">- allows '); dbms_lob.writeappend(clob_loc, 74, ' you to purge obsolete Warehouse Builder Browser settings.</font></li> '); dbms_lob.writeappend(clob_loc, 111, ' <li><b><font face="Arial" size="2">Resource Management</font></b><font face="Arial" size="2">- allows you to '); dbms_lob.writeappend(clob_loc, 81, ' manage access privileges to Warehouse Builder Browser resources.</font></li> '); dbms_lob.writeappend(clob_loc, 115, ' <li><b><font face="Arial" size="2">Manage Preferences</font></b><font face="Arial" size="2">- allows you to save '); dbms_lob.writeappend(clob_loc, 76, ' and load preference settings from files or existing schema.</font></li> '); dbms_lob.writeappend(clob_loc, 115, ' <li><b><font face="Arial" size="2">Manage Dependency Index</font></b><font face="Arial" size="2">- allows you to '); dbms_lob.writeappend(clob_loc, 92, ' improve performance by specifying how often to refresh the Dependency Index</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 80, '<p><font size="2" face="Arial">The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.</font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 49, ' <table border="1" width="515" cellspacing="1"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="155" valign="top" align="left"><b><font size="2" face="Arial">Action '); dbms_lob.writeappend(clob_loc, 29, ' Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="344" valign="top" align="left"><b><font size="2" face="Arial">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 93, ' <td valign="top" align="left" width="155"><font size="2" face="Arial">Help</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 94, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">About</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="155" valign="top" align="left"><font face="Arial" size="2">Full '); dbms_lob.writeappend(clob_loc, 25, ' Page</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' </table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/admn_prg.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_prg.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_prg.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 46, '<title>Purging Stale User Information</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 70, '<p><font face="Arial Black">Purging Stale User Information</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 110, '<p><font face="Arial" size="2">Use the <u> Purge Stale User Information</u> action link to remove information '); dbms_lob.writeappend(clob_loc, 76, 'relating to users who have been deleted from the single sign-on repository. '); dbms_lob.writeappend(clob_loc, 69, 'This information remains within the Warehouse Builder Browser system '); dbms_lob.writeappend(clob_loc, 78, 'repository until it is removed using this operation. There is no confirmation '); dbms_lob.writeappend(clob_loc, 91, 'page. The stale information is purged when the Administration page re-displays.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/admn_reg_rep.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_reg_rep.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_reg_rep.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 40, '<title>Registering a Repository</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 64, '<p><font face="Arial Black">Registering a Repository</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 77, 'Use the Register Repository page to register a repository with the Warehouse '); dbms_lob.writeappend(clob_loc, 121, 'Builder Brower as well as link to the Administer Database Links page. Click <b>OK</b> to commit changes. Click <b>Cancel '); dbms_lob.writeappend(clob_loc, 31, '</b>to discard changes.</font> '); dbms_lob.writeappend(clob_loc, 97, '<p><font face="Arial" size="2">Fill in the following fields to register a repository:</font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="64%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 104, ' <td width="19%" valign="top" align="left"><b><font face="Arial" size="2">Field Name</font></b></td> '); dbms_lob.writeappend(clob_loc, 105, ' <td width="81%" valign="top" align="left"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 91, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">Name</font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2">The name '); dbms_lob.writeappend(clob_loc, 45, ' the repository will be known as within '); dbms_lob.writeappend(clob_loc, 92, 'the Warehouse Builder Browser system. For example, this name is displayed in the navigation '); dbms_lob.writeappend(clob_loc, 19, 'pages.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 96, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">Host Name</font></td> '); dbms_lob.writeappend(clob_loc, 112, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2">The name of the computer on which the '); dbms_lob.writeappend(clob_loc, 74, 'repository is stored. This name must be identical to the name used within '); dbms_lob.writeappend(clob_loc, 79, 'the Warehouse Builder client or else it will not be possible to invoke reports '); dbms_lob.writeappend(clob_loc, 49, 'for this repository from the client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 99, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">Database SID</font></td> '); dbms_lob.writeappend(clob_loc, 112, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2"> The SID of the database in which the '); dbms_lob.writeappend(clob_loc, 74, 'repository is stored. This name must be identical to the name used within '); dbms_lob.writeappend(clob_loc, 79, 'the Warehouse Builder client or else it will not be possible to invoke reports '); dbms_lob.writeappend(clob_loc, 30, 'from that client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 108, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">OWB Repository Schema</font></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2"> The name of the schema in which '); dbms_lob.writeappend(clob_loc, 71, 'the repository is stored. This name must be identical to the name used '); dbms_lob.writeappend(clob_loc, 78, 'within the Warehouse Builder client or else it will not be possible to invoke '); dbms_lob.writeappend(clob_loc, 38, 'reports from that client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 100, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">Database Link</font></td> '); dbms_lob.writeappend(clob_loc, 111, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2"> The name of the database link which '); dbms_lob.writeappend(clob_loc, 73, 'should be used to access the repository. The link must already have been '); dbms_lob.writeappend(clob_loc, 81, 'created, using SQL*Plus for example. This field must be specified and must refer '); dbms_lob.writeappend(clob_loc, 88, 'to a valid link even if the repository is on the same database as the Warehouse Builder '); dbms_lob.writeappend(clob_loc, 34, ' Browser system.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 98, ' <td width="19%" valign="top" align="left"><font face="Arial" size="2">Description</font></td> '); dbms_lob.writeappend(clob_loc, 117, ' <td width="81%" valign="top" align="left"><font face="Arial" size="2"> The descriptive text which appears within '); dbms_lob.writeappend(clob_loc, 77, 'the navigation pages for this repository. (4000 character limit)</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/admn_reg_rpt.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('admn_reg_rpt.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'admn_reg_rpt.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 42, '<title>Registering Custom Reports</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 66, '<p><font face="Arial Black">Registering Custom Reports</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 64, '<p><font size="2" face="Arial">Use the Register a Custom Report '); dbms_lob.writeappend(clob_loc, 66, 'page to define a Custom Report. A Custom Report is an application '); dbms_lob.writeappend(clob_loc, 54, 'component created using the Oracle Portal facilities. '); dbms_lob.writeappend(clob_loc, 66, 'Registration of the report provides the Warehouse Builder Browser '); dbms_lob.writeappend(clob_loc, 62, 'system with the information required to invoke the report. In '); dbms_lob.writeappend(clob_loc, 64, 'order for the report to be available, you must assign it to one '); dbms_lob.writeappend(clob_loc, 61, 'or more roles after registration. For more information about '); dbms_lob.writeappend(clob_loc, 66, 'assigning roles, see </font><a href="@rsrcmgnt_rolacc.html"><font '); dbms_lob.writeappend(clob_loc, 72, 'size="2" face="Arial">Granting and Revoking Role Access</font></a><font '); dbms_lob.writeappend(clob_loc, 36, 'size="2" face="Arial">.</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font size="2" face="Arial">Fill in the following fields to '); dbms_lob.writeappend(clob_loc, 37, 'register a Custom Report:</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 82, ' <td width="31%"><font size="2" face="Arial"><b>Field Name</b></font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="69%"><font size="2" face="Arial"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 77, ' <td width="31%"><font size="2" face="Arial">Display Name</font></td> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="69%"><font size="2" face="Arial">The name of '); dbms_lob.writeappend(clob_loc, 71, ' the report which is seen in the reports list page.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 74, ' <td width="31%"><font size="2" face="Arial">Type Name</font></td> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="69%"><font size="2" face="Arial">The name of '); dbms_lob.writeappend(clob_loc, 62, ' the data type reported on by this report.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="31%"><font size="2" face="Arial">Package</font></td> '); dbms_lob.writeappend(clob_loc, 66, ' <td width="69%"><font size="2" face="Arial">The full name '); dbms_lob.writeappend(clob_loc, 72, ' of the PL/SQL package which implements this report.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 75, ' <td width="31%"><font size="2" face="Arial">Repository</font></td> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="69%"><font size="2" face="Arial">The name of '); dbms_lob.writeappend(clob_loc, 78, ' the repository containing target objects for this report.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/fav_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('fav_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'fav_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 37, '<title>Customizing Favorites</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 61, '<p><font face="Arial Black">Customizing Favorites</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 16, '<font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 77, '<p><font face="Arial" size="2">Use the Customize Warehouse Builder Favorites '); dbms_lob.writeappend(clob_loc, 62, 'page to change the way your Favorites appear on the Favorites '); dbms_lob.writeappend(clob_loc, 17, 'Page.</font></p> '); dbms_lob.writeappend(clob_loc, 57, '<p><font face="Arial"><b>Select Favorites</b></font></p> '); dbms_lob.writeappend(clob_loc, 79, '<p><font face="Arial">Use the drop down lists to select a Repository, Role, or '); dbms_lob.writeappend(clob_loc, 79, 'Type of Favorite that you want to have displayed on your Favorites pages. This '); dbms_lob.writeappend(clob_loc, 81, 'is a filter for the type of items that display in your Favorites. This is useful '); dbms_lob.writeappend(clob_loc, 85, 'if you do not want to set the filter each time you open a Favorites page.</font></p> '); dbms_lob.writeappend(clob_loc, 55, '<p><font face="Arial"><b>Edit Favorites</b></font></p> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial">Use the Edit Favorites link to edit the descriptions of '); dbms_lob.writeappend(clob_loc, 58, 'your Favorites, and to delete Favorites. </font></p> '); dbms_lob.writeappend(clob_loc, 57, '<p><font face="Arial"><b>Display Settings</b></font></p> '); dbms_lob.writeappend(clob_loc, 79, '<p><font face="Arial">Use the display settings options to specify how you want '); dbms_lob.writeappend(clob_loc, 38, 'the page to display. </font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="99%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="21%"><font face="Arial" size="2"><b>Type</b></font></td> '); dbms_lob.writeappend(clob_loc, 74, ' <td width="29%"><font face="Arial" size="2"><b>Option</b></font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="50%"><font face="Arial" size="2"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 80, ' <td width="21%" rowspan="2"><font face="Arial" size="2">Display</font></td> '); dbms_lob.writeappend(clob_loc, 69, ' <td width="29%"><font face="Arial" size="2">Show All</font></td> '); dbms_lob.writeappend(clob_loc, 52, ' <td width="50%"><font face="Arial" size="2">The '); dbms_lob.writeappend(clob_loc, 76, 'Navigation List and the Reports List will contain all entries that you have '); dbms_lob.writeappend(clob_loc, 19, 'added.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="29%"><font face="Arial" size="2">Limit List To n Favorites</font></td> '); dbms_lob.writeappend(clob_loc, 52, ' <td width="50%"><font face="Arial" size="2">You '); dbms_lob.writeappend(clob_loc, 78, 'can choose the maximum number of rows you wish to see in the tables. If there '); dbms_lob.writeappend(clob_loc, 78, 'are more items than can be shown, you will see Next and Previous buttons that '); dbms_lob.writeappend(clob_loc, 52, 'you can use to see the remaining items.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 77, ' <td width="21%"><font face="Arial" size="2">Show Description</font></td> '); dbms_lob.writeappend(clob_loc, 67, ' <td width="29%"><font face="Arial" size="2">Yes/No</font></td> '); dbms_lob.writeappend(clob_loc, 52, ' <td width="50%"><font face="Arial" size="2">You '); dbms_lob.writeappend(clob_loc, 66, 'can stop the description column from being displayed.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 70, ' <td width="21%"><font face="Arial" size="2">Show Path</font></td> '); dbms_lob.writeappend(clob_loc, 67, ' <td width="29%"><font face="Arial" size="2">Yes/No</font></td> '); dbms_lob.writeappend(clob_loc, 52, ' <td width="50%"><font face="Arial" size="2">You '); dbms_lob.writeappend(clob_loc, 78, 'can stop the path column from being displayed. The path can be quite long and '); dbms_lob.writeappend(clob_loc, 36, 'can clutter the screen.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 8, '</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/fav_edit.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('fav_edit.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'fav_edit.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 33, '<title>Editing Favorites</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 57, '<p><font face="Arial Black">Editing Favorites</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 16, '<font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2">To edit your favorites page, select one of the '); dbms_lob.writeappend(clob_loc, 35, 'following action links:</font></p> '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="26%"><font face="Arial" size="2"><b>Action Link</b></font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="74%"><font face="Arial" size="2"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 65, ' <td width="26%"><font face="Arial" size="2">Edit</font></td> '); dbms_lob.writeappend(clob_loc, 87, ' <td width="74%"><font face="Arial" size="2">The <u>edit</u> action link allows you '); dbms_lob.writeappend(clob_loc, 74, 'to change the description for this Favorite. The description appears as a '); dbms_lob.writeappend(clob_loc, 42, 'column in the Favorites list.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 82, ' <td width="26%"><font face="Arial" size="2">Delete From Favorites</font></td> '); dbms_lob.writeappend(clob_loc, 88, ' <td width="74%"><font face="Arial" size="2">The <u>delete from favorites</u> action '); dbms_lob.writeappend(clob_loc, 11, ' link '); dbms_lob.writeappend(clob_loc, 78, 'removes this entry from the Favorites table. It does not remove the item from '); dbms_lob.writeappend(clob_loc, 46, 'the Warehouse Builder Repository.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 8, '</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/fav_main.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('fav_main.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'fav_main.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 43, '<title>Warehouse Builder Favorites</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 76, '<p><font face="Arial Black" size="3">Warehouse Builder Favorites</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 84, 'Selecting <u> Browse My Favorites</u> allows you to jump directly to your Warehouse '); dbms_lob.writeappend(clob_loc, 78, 'Builder Favorites page. Every navigation page and every report has an <u> Add '); dbms_lob.writeappend(clob_loc, 79, 'to My Favorites</u> link on the top right corner. When you selected this link, '); dbms_lob.writeappend(clob_loc, 71, 'a link to the report or Navigation page you are looking at is added to '); dbms_lob.writeappend(clob_loc, 76, 'your Favorites list. You can also use the features on these pages to delete '); dbms_lob.writeappend(clob_loc, 69, 'items from the list and to change the formatting of the list.</font> '); dbms_lob.writeappend(clob_loc, 91, '<p><font face="Arial" size="2">The Navigation pages consist of the following parts:</font> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 69, '<a href="#Header"><font face="Arial" size="2">Header</font></a></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 69, '<a href="#Filter"><font face="Arial" size="2">Filter</font></a></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 87, '<a href="#Navigation"><font face="Arial" size="2">Navigation Favorites</font></a></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 81, '<a href="#Reports"><font face="Arial" size="2">Reports Favorites</font></a></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<h2> '); dbms_lob.writeappend(clob_loc, 103, '<a NAME="Header"><font face="Arial" size="2"></font></a><font face="Arial" size="2">Header</font></h2> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 79, 'The header defines the type of page you are looking at, in this case Warehouse '); dbms_lob.writeappend(clob_loc, 75, 'Builder Favorites, and has links to your default home page, your Favorites '); dbms_lob.writeappend(clob_loc, 33, 'customization page, and log out. '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 39, '<br>The header contains the following: '); dbms_lob.writeappend(clob_loc, 18, '<br> </font> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="631" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 91, '<td width="96" valign="top" align="left"><font face="Arial" size="2">The Title</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, '<td width="519" valign="top" align="left"><font face="Arial" size="2">The title '); dbms_lob.writeappend(clob_loc, 53, ' describes the type of page displayed. For example, '); dbms_lob.writeappend(clob_loc, 80, 'in this case you are looking at a Warehouse Builder Favorites page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 95, '<td width="96" valign="top" align="left"><font face="Arial" size="2">The Home Link</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 129, '<td width="519" valign="top" align="left"><font face="Arial" size="2">This link takes you to your default home page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 90, '<td width="96" valign="top" align="left"><font face="Arial" size="2">The Date</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 138, '<td width="519" valign="top" align="left"><font face="Arial" size="2">The date shows you when the page was displayed. This is only useful '); dbms_lob.writeappend(clob_loc, 76, 'if you print the page, otherwise it is always the current date.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 91, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Customize</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 138, '<td width="519" valign="top" align="left"><font face="Arial" size="2">Select this link to go to the Customize Warehouse Builder Favorites '); dbms_lob.writeappend(clob_loc, 44, 'Pages page and customize your page display. '); dbms_lob.writeappend(clob_loc, 76, '<br>For details about customizing your page, see Customizing Your Favorites '); dbms_lob.writeappend(clob_loc, 18, 'Page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 88, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Logout</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 128, '<td width="519" valign="top" align="left"><font face="Arial" size="2">Select this link to log out of Oracle Portal.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<h2> '); dbms_lob.writeappend(clob_loc, 103, '<a NAME="Filter"><font face="Arial" size="2"></font></a><font face="Arial" size="2">Filter</font></h2> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 72, 'You can narrow down the content of the two Favorite Tables by selecting '); dbms_lob.writeappend(clob_loc, 71, 'a particular Repository, Role or Item Type. Each of these Items has an '); dbms_lob.writeappend(clob_loc, 19, 'All option.</font> '); dbms_lob.writeappend(clob_loc, 5, '<h2> '); dbms_lob.writeappend(clob_loc, 121, '<a NAME="Navigation"><font face="Arial" size="2"></font></a><font face="Arial" size="2">Navigation Favorites</font></h2> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 79, 'This list contains all of the Navigator pages contained in your Favorites. Use '); dbms_lob.writeappend(clob_loc, 73, 'the <u>Add to My Favorites</u> link at the top right hand corner of each '); dbms_lob.writeappend(clob_loc, 58, 'Navigator page to add the current page to your Favorites. '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 38, '<br>The table contains these columns: '); dbms_lob.writeappend(clob_loc, 18, '<br> </font> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="631" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 86, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Type</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 148, '<td width="519" valign="top" align="left"><font face="Arial" size="2">The Type of the item together with an icon representing the type.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 86, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Name</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 137, '<td width="519" valign="top" align="left"><font face="Arial" size="2">The name of the Item. Selecting the name will take you straight to '); dbms_lob.writeappend(clob_loc, 54, 'the Navigation content page of that item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 86, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Path</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 142, '<td width="519" valign="top" align="left"><font face="Arial" size="2">The Path shows the fully qualified name of the item (as it would appear '); dbms_lob.writeappend(clob_loc, 80, 'in the Path field on the Navigator page). If you find the Page is to cluttered, '); dbms_lob.writeappend(clob_loc, 88, 'then this column can be removed using the Favorites Customize Options Page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 89, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Actions</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 139, '<td width="519" valign="top" align="left"><font face="Arial" size="2">These Actions allow you to jump to the specific tab in the Navigator '); dbms_lob.writeappend(clob_loc, 27, 'for that item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 93, '<td width="96" valign="top" align="left"><font face="Arial" size="2">Description</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 140, '<td width="519" valign="top" align="left"><font face="Arial" size="2">You can create a description to a favorite in the Favorites Customize '); dbms_lob.writeappend(clob_loc, 36, 'Page. It displays here.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<h2> '); dbms_lob.writeappend(clob_loc, 115, '<a NAME="Reports"><font face="Arial" size="2"></font></a><font face="Arial" size="2">Reports Favorites</font></h2> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 103, 'This list contains all of the reports contained in your Favorites. Use the <u> Add to My Favorites</u> '); dbms_lob.writeappend(clob_loc, 75, 'link at the top right hand corner of each report to add the report to your '); dbms_lob.writeappend(clob_loc, 18, 'Favorites.</font> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 41, 'The table contains these columns:</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="630" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 60, '<td width="95"><font face="Arial" size="2">Type</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 122, '<td width="519"><font face="Arial" size="2">The Type of the item together with an icon representing the type.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 60, '<td width="95"><font face="Arial" size="2">Name</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 111, '<td width="519"><font face="Arial" size="2">The name of the Item. Selecting the name will take you straight to '); dbms_lob.writeappend(clob_loc, 54, 'the Navigation content page of that item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 62, '<td width="95"><font face="Arial" size="2">Report</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 113, '<td width="519"><font face="Arial" size="2">The name of the Report. Selecting the report name takes you straight '); dbms_lob.writeappend(clob_loc, 27, 'to the report.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 60, '<td width="95"><font face="Arial" size="2">Path</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 116, '<td width="519"><font face="Arial" size="2">The Path shows the fully qualified name of the item (as it would appear '); dbms_lob.writeappend(clob_loc, 80, 'in the Path field on the Navigator page). If you find the Page is to cluttered, '); dbms_lob.writeappend(clob_loc, 78, 'then this column can be removed using the Favorites Options Page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 67, '<td width="95"><font face="Arial" size="2">Description</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, '<td width="519"><font face="Arial" size="2">You can create a description to a favorite in the Favorites Customize '); dbms_lob.writeappend(clob_loc, 36, 'Page. It displays here.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 9, '<center> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 10, '</center> '); dbms_lob.close(clob_loc); --text document 'us/fav_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('fav_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'fav_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 51, '<title>Warehouse Builder Favorites Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 84, '<p><font face="Arial Black" size="3">Warehouse Builder Favorites Portlet</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2">Use the Warehouse Builder Favorites Portlet to '); dbms_lob.writeappend(clob_loc, 108, 'access your favorite Navigator pages and Reports directly from your Oracle Portal home page. When you '); dbms_lob.writeappend(clob_loc, 81, 'install this portlet, it does not contain any default favorites. You must select '); dbms_lob.writeappend(clob_loc, 78, 'Navigator pages and Reports as favorites using the <u>Add to My Favorites</u> '); dbms_lob.writeappend(clob_loc, 82, 'links on the Warehouse Builder Navigator. You can also click the <u>Full Page</u> '); dbms_lob.writeappend(clob_loc, 56, 'link to display Favorites in full page mode.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 88, ' <li><b><font size="2" face="Arial">To view your favorite Navigator pages: </font></b> '); dbms_lob.writeappend(clob_loc, 33, ' <font size="2" face="Arial"> '); dbms_lob.writeappend(clob_loc, 81, ' Select an item name under the column Name. You can also use the action links '); dbms_lob.writeappend(clob_loc, 80, ' to view the properties, contents, related items, or reports that are linked '); dbms_lob.writeappend(clob_loc, 37, ' to this item. </font></li> '); dbms_lob.writeappend(clob_loc, 118, ' <li><b><font size="2" face="Arial">To view your favorite Reports: </font></b> <font size="2" face="Arial"> Select a '); dbms_lob.writeappend(clob_loc, 81, ' report name under the Report column. If you click on the item name under the '); dbms_lob.writeappend(clob_loc, 73, ' column Name, the Navigator page for that item displays. </font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 80, '<p><font size="2" face="Arial">The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.</font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 49, ' <table border="1" width="515" cellspacing="1"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="155" valign="top" align="left"><b><font size="2" face="Arial">Action '); dbms_lob.writeappend(clob_loc, 29, ' Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="344" valign="top" align="left"><b><font size="2" face="Arial">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 98, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">Customize</font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 93, ' <td valign="top" align="left" width="155"><font size="2" face="Arial">Help</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 94, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">About</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="155" valign="top" align="left"><font face="Arial" size="2">Full '); dbms_lob.writeappend(clob_loc, 25, ' Page</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' </table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.close(clob_loc); --text document 'us/laun_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('laun_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'laun_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 50, '<title>Warehouse Builder Launcher Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 76, '<font face="Arial Black" size="3">Warehouse Builder Launcher Portlet</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 95, '<p><font face="Arial" size="2">Use the Warehouse Builder Launcher Portlet to: </font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 108, ' <li><b><font face="Arial" size="2">Browse a Repository </font> </b><font face="Arial" size="2">- Select a '); dbms_lob.writeappend(clob_loc, 78, ' role and click <b> Browse</b> to browse the repositories available to the '); dbms_lob.writeappend(clob_loc, 72, ' current user. The Warehouse Builder Navigator displays in full page '); dbms_lob.writeappend(clob_loc, 79, ' mode. You can select from a list of repositories, and use the Navigator to '); dbms_lob.writeappend(clob_loc, 58, ' view the detail of that repository. </font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 119, ' <li><b><font face="Arial" size="2">Browse My Favorites </font> </b><font face="Arial" size="2">- Select this link to '); dbms_lob.writeappend(clob_loc, 78, ' view the Warehouse Builder Favorites in full page mode. </font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 94, ' <li><font face="Arial"><b><font size="2">Administer Warehouse Builder Browser </font> </b>- '); dbms_lob.writeappend(clob_loc, 113, ' <font face="Arial" size="2">Select this link to view the Warehouse Builder Administration in full page mode. '); dbms_lob.writeappend(clob_loc, 77, ' Use these pages to set up and configure your Browser.</font></font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_addlnk.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_addlnk.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_addlnk.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 28, '<title>Adding Links</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial Black" size="3">Adding Links to the Navigator</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 103, '<p><font face="Arial" size="2">Use the Add Link page to add links to other portals, files, or external '); dbms_lob.writeappend(clob_loc, 24, 'URLs. If you are adding '); dbms_lob.writeappend(clob_loc, 79, 'files, you must first make sure that the file exists in a portal content area. '); dbms_lob.writeappend(clob_loc, 71, 'For more information, see the Oracle Portal documentation. </font></p> '); dbms_lob.writeappend(clob_loc, 92, '<p><font face="Arial" size="2">To add a link, provide the following information:</font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="59%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 73, ' <td width="16%"><b><font face="Arial" size="2">Field</font></b></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="84%"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 73, ' <td width="16%"><font face="Arial" size="2">Display Name</font></td> '); dbms_lob.writeappend(clob_loc, 88, ' <td width="84%"><font face="Arial" size="2">Create a name for the link.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="16%"><font face="Arial" size="2">URL</font></td> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="84%"><font face="Arial" size="2"> For an external website, provide the '); dbms_lob.writeappend(clob_loc, 27, 'complete URL. </font> '); dbms_lob.writeappend(clob_loc, 98, ' <p><font face="Arial" size="2"> For files that are in a Oracle Portal content area, use the '); dbms_lob.writeappend(clob_loc, 75, 'right-click Copy Shortcut to copy the location of the file. Then use Paste '); dbms_lob.writeappend(clob_loc, 64, 'into this field to define the location of the file.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 78, ' <td width="16%"><font face="Arial" size="2">Description </font></td> '); dbms_lob.writeappend(clob_loc, 76, ' <td width="84%"><font face="Arial" size="2"> Create a short description '); dbms_lob.writeappend(clob_loc, 26, 'of this link.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_cnts.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_cnts.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_cnts.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 45, '<meta name="Author" content="Geoff Watters"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 38, '<title>Navigator Contents Tab</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 71, '<p><font size="3" face="Arial Black">Navigator Contents Tab</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<p><font size="2" face="Arial">The Contents tab lists items '); dbms_lob.writeappend(clob_loc, 64, 'contained in the current item. For example, if the current item '); dbms_lob.writeappend(clob_loc, 64, 'was a table, then the Contents tab would list its columns, keys '); dbms_lob.writeappend(clob_loc, 65, 'and foreign keys. Use this tab to drill down into the Repository '); dbms_lob.writeappend(clob_loc, 66, 'using <u>contents</u> on an item in the list. The following table '); dbms_lob.writeappend(clob_loc, 47, 'describes the Contents tab column values. <br> '); dbms_lob.writeappend(clob_loc, 18, ' </font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="466"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 74, ' <td valign="top" width="98"><font size="2" face="Arial"><b>Column '); dbms_lob.writeappend(clob_loc, 29, ' Name</b></font></td> '); dbms_lob.writeappend(clob_loc, 96, ' <td valign="top" width="352"><font size="2" face="Arial"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 73, ' <td valign="top" width="98"><font size="2" face="Arial">Physical '); dbms_lob.writeappend(clob_loc, 25, ' Name</font></td> '); dbms_lob.writeappend(clob_loc, 69, ' <td valign="top" width="352"><font size="2" face="Arial">The '); dbms_lob.writeappend(clob_loc, 47, ' physical name of the item.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 81, ' <td valign="top" width="98"><font size="2" face="Arial">Type</font></td> '); dbms_lob.writeappend(clob_loc, 68, ' <td valign="top" width="352"><font size="2" face="Arial">An '); dbms_lob.writeappend(clob_loc, 63, ' icon showing a graphical representation of the of item '); dbms_lob.writeappend(clob_loc, 49, ' type and the item type name.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 84, ' <td valign="top" width="98"><font size="2" face="Arial">Actions</font></td> '); dbms_lob.writeappend(clob_loc, 71, ' <td valign="top" width="352"><font size="2" face="Arial">There '); dbms_lob.writeappend(clob_loc, 59, ' are two types of actions: generic actions and item '); dbms_lob.writeappend(clob_loc, 66, ' specific actions. Generic actions are available for every '); dbms_lob.writeappend(clob_loc, 63, ' item and are intended to help navigate the repository. '); dbms_lob.writeappend(clob_loc, 64, ' Item specific actions are only available for particular '); dbms_lob.writeappend(clob_loc, 64, ' items or item types and either perform tasks or link to '); dbms_lob.writeappend(clob_loc, 72, ' external data.</font> <p><font size="2" face="Arial"><b>Generic '); dbms_lob.writeappend(clob_loc, 32, ' Actions:</b></font></p> '); dbms_lob.writeappend(clob_loc, 13, ' <ul> '); dbms_lob.writeappend(clob_loc, 69, ' <li><font size="2" face="Arial"><u>properties</u></font> '); dbms_lob.writeappend(clob_loc, 61, ' <font size="2" face="Arial">- selecting this '); dbms_lob.writeappend(clob_loc, 59, ' action link makes the item on that row the '); dbms_lob.writeappend(clob_loc, 59, ' current item and takes you straight to the '); dbms_lob.writeappend(clob_loc, 64, ' Properties tab for that item. </font></li> '); dbms_lob.writeappend(clob_loc, 67, ' <li><font size="2" face="Arial"><u>contents</u></font> '); dbms_lob.writeappend(clob_loc, 61, ' <font size="2" face="Arial">- selecting this '); dbms_lob.writeappend(clob_loc, 59, ' action link makes the item on that row the '); dbms_lob.writeappend(clob_loc, 59, ' current item and takes you straight to the '); dbms_lob.writeappend(clob_loc, 56, ' Contents tab for that item.</font></li> '); dbms_lob.writeappend(clob_loc, 66, ' <li><font size="2" face="Arial"><u>related</u></font> '); dbms_lob.writeappend(clob_loc, 61, ' <font size="2" face="Arial">- selecting this '); dbms_lob.writeappend(clob_loc, 59, ' action link makes the item on that row the '); dbms_lob.writeappend(clob_loc, 59, ' current item and takes you straight to the '); dbms_lob.writeappend(clob_loc, 55, ' Related tab for that item.</font></li> '); dbms_lob.writeappend(clob_loc, 66, ' <li><font size="2" face="Arial"><u>reports</u></font> '); dbms_lob.writeappend(clob_loc, 61, ' <font size="2" face="Arial">- selecting this '); dbms_lob.writeappend(clob_loc, 59, ' action link makes the item on that row the '); dbms_lob.writeappend(clob_loc, 66, ' current item and take you straight to the Reports '); dbms_lob.writeappend(clob_loc, 53, ' tab for that item. </font></li> '); dbms_lob.writeappend(clob_loc, 70, ' <li><font size="2" face="Arial"><u>links</u></font> <font '); dbms_lob.writeappend(clob_loc, 62, ' size="2" face="Arial">- selecting this action '); dbms_lob.writeappend(clob_loc, 65, ' link makes the item on that row the current item '); dbms_lob.writeappend(clob_loc, 65, ' and takes you straight to the Links tab for that '); dbms_lob.writeappend(clob_loc, 34, ' item.</font></li> '); dbms_lob.writeappend(clob_loc, 14, ' </ul> '); dbms_lob.writeappend(clob_loc, 64, ' <p><font size="2" face="Arial">Note: You can also '); dbms_lob.writeappend(clob_loc, 65, ' use <u>contents</u> to select a new item and then switch '); dbms_lob.writeappend(clob_loc, 67, ' tabs when the screen has refreshed. The <u>properties</u>, '); dbms_lob.writeappend(clob_loc, 63, ' <u>related</u>, <u>reports</u> and <u>links</u> action '); dbms_lob.writeappend(clob_loc, 40, ' links are shortcuts.</font></p> '); dbms_lob.writeappend(clob_loc, 80, ' <p><font size="2" face="Arial"><b>Item Specific Actions:</b></font></p> '); dbms_lob.writeappend(clob_loc, 13, ' <ul> '); dbms_lob.writeappend(clob_loc, 66, ' <li><font size="2" face="Arial"><u>refresh dependency '); dbms_lob.writeappend(clob_loc, 63, ' index</u></font> <font size="2" face="Arial">- '); dbms_lob.writeappend(clob_loc, 60, ' selecting this action link takes you to the '); dbms_lob.writeappend(clob_loc, 64, ' Refresh Dependency Index page. This action link '); dbms_lob.writeappend(clob_loc, 60, ' only displays for Repositories.</font></li> '); dbms_lob.writeappend(clob_loc, 63, ' <li><font size="2" face="Arial">External links can '); dbms_lob.writeappend(clob_loc, 63, ' also display as item specific actions. Specify '); dbms_lob.writeappend(clob_loc, 64, ' which items should be affiliated with each link '); dbms_lob.writeappend(clob_loc, 63, ' when you define the external link.</font></li> '); dbms_lob.writeappend(clob_loc, 14, ' </ul> '); dbms_lob.writeappend(clob_loc, 14, ' </td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font size="2" face="Arial">The other tabs in the </font><a '); dbms_lob.writeappend(clob_loc, 76, 'href="@nav_main.html"><font size="2" face="Arial">Navigator</font></a><font '); dbms_lob.writeappend(clob_loc, 68, 'size="2" face="Arial"> allow you to navigate and view the </font><a '); dbms_lob.writeappend(clob_loc, 78, 'href="@nav_prpts.html"><font size="2" face="Arial">properties</font></a><font '); dbms_lob.writeappend(clob_loc, 62, 'size="2" face="Arial">, </font><a href="@nav_rltd.html"><font '); dbms_lob.writeappend(clob_loc, 61, 'size="2" face="Arial">related items</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 62, 'face="Arial">, </font><a href="@nav_rpts.html"><font size="2" '); dbms_lob.writeappend(clob_loc, 65, 'face="Arial">reports</font></a><font size="2" face="Arial">, and '); dbms_lob.writeappend(clob_loc, 61, 'links that are applicable to the current object.</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/nav_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 57, '<title>Customizing the Navigator Display Options</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<font face="Arial Black">Customizing the Navigator Display '); dbms_lob.writeappend(clob_loc, 15, 'Options</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">Use the Customize Display Options page to set up '); dbms_lob.writeappend(clob_loc, 78, 'the Navigator. There are two sets of options for you to set. </font></p> '); dbms_lob.writeappend(clob_loc, 64, '<p><b><font face="Arial" size="2">Role Selection</font></b></p> '); dbms_lob.writeappend(clob_loc, 72, '<p><font size="2" face="Arial">Select the role you want to use with the '); dbms_lob.writeappend(clob_loc, 67, 'Navigator. These roles are defined in the following table. Use the '); dbms_lob.writeappend(clob_loc, 97, 'Administration pages to assign access to roles. The default is <i>Warehouse User</i>.</font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="89%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="28%"><b><font face="Arial" size="2">Role</font></b></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="72%"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 80, ' <td width="28%"><font SIZE="2" face="Arial">Warehouse Developer</font></td> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="72%"><font SIZE="2" face="Arial">User that uses Warehouse Builder '); dbms_lob.writeappend(clob_loc, 43, ' to create the warehouse.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 74, ' <td width="28%"><font SIZE="2" face="Arial">QA User </font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="72%"><font SIZE="2" face="Arial">User that tests the quality of '); dbms_lob.writeappend(clob_loc, 55, ' the warehouse before it is deployed.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 75, ' <td width="28%"><font SIZE="2" face="Arial">Warehouse User</font></td> '); dbms_lob.writeappend(clob_loc, 76, ' <td width="72%"><font SIZE="2" face="Arial">User that uses the deployed '); dbms_lob.writeappend(clob_loc, 67, ' Warehouse to understand the underlying metadata.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 13, '<blockquote> '); dbms_lob.writeappend(clob_loc, 15, ' <blockquote> '); dbms_lob.writeappend(clob_loc, 17, ' <blockquote> '); dbms_lob.writeappend(clob_loc, 19, ' <blockquote> '); dbms_lob.writeappend(clob_loc, 21, ' <blockquote> '); dbms_lob.writeappend(clob_loc, 22, ' </blockquote> '); dbms_lob.writeappend(clob_loc, 20, ' </blockquote> '); dbms_lob.writeappend(clob_loc, 18, ' </blockquote> '); dbms_lob.writeappend(clob_loc, 16, ' </blockquote> '); dbms_lob.writeappend(clob_loc, 14, '</blockquote> '); dbms_lob.writeappend(clob_loc, 67, '<p><b><font face="Arial" size="2">Display Selection</font></b></p> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">Specify how many items you want displayed within '); dbms_lob.writeappend(clob_loc, 56, 'the portlet. The default is <i>Show All</i>.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 87, ' <li><b><font face="Arial" size="2">Show All</font></b> <font face="Arial" size="2">- '); dbms_lob.writeappend(clob_loc, 54, ' displays all items within the portlet</font></li> '); dbms_lob.writeappend(clob_loc, 77, ' <li><b><font face="Arial" size="2">Limit List to n '); dbms_lob.writeappend(clob_loc, 79, ' Items</font></b> <font face="Arial" size="2">- displays only the specified '); dbms_lob.writeappend(clob_loc, 52, ' number of items within the portlet.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_cst_lnks.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_cst_lnks.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_cst_lnks.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 33, '<title>Customizing Links</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, '<p><font face="Arial Black">Customizing Links in the Navigator</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">Use the Customize Warehouse Builder Links page to '); dbms_lob.writeappend(clob_loc, 53, 'edit to the links you have set up. </font> </p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="55%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 20, ' <font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="23%"><b><font face="Arial" size="2">Action Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="77%"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 12, ' </font> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 20, ' <font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 65, ' <td width="23%"><font face="Arial" size="2">Edit</font></td> '); dbms_lob.writeappend(clob_loc, 76, ' <td width="77%"><font face="Arial" size="2">The <u>edit</u> action link '); dbms_lob.writeappend(clob_loc, 81, ' allows you to make changes to this information about the link.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </font> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 20, ' <font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 68, ' <td width="23%"><font face="Arial" size="2">Delete </font></td> '); dbms_lob.writeappend(clob_loc, 78, ' <td width="77%"><font face="Arial" size="2">The <u>delete</u> action link '); dbms_lob.writeappend(clob_loc, 68, ' removes this link from the Existing Links table. </font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </font> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2"><b>NOTE:</b> Links cannot be added to the root of '); dbms_lob.writeappend(clob_loc, 85, 'the Navigator. The root of the Navigator list all available repositories.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_lia.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_lia.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_lia.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 45, '<meta name="Author" content="Nigel Baldwin"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 43, '<title>Lineage and Imapct Analysis</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 65, '<p><font size="3" face="Arial Black">Lineage and Impact Analysis '); dbms_lob.writeappend(clob_loc, 19, 'Reports</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 36, '<p><font size="2" face="Arial"><br> '); dbms_lob.writeappend(clob_loc, 80, '</font><a href="#Overview"><font size="2" face="Arial">Overview</font></a><font '); dbms_lob.writeappend(clob_loc, 28, 'size="2" face="Arial"> <br> '); dbms_lob.writeappend(clob_loc, 70, '</font><a href="#RepeatedObject"><font size="2" face="Arial">Repeated '); dbms_lob.writeappend(clob_loc, 52, 'Objects</font></a><font size="2" face="Arial"> <br> '); dbms_lob.writeappend(clob_loc, 69, '</font><a href="#DisplayOptions"><font size="2" face="Arial">Display '); dbms_lob.writeappend(clob_loc, 52, 'Options</font></a><font size="2" face="Arial"> <br> '); dbms_lob.writeappend(clob_loc, 84, '</font><a href="#Navigation"><font size="2" face="Arial">Navigation</font></a><font '); dbms_lob.writeappend(clob_loc, 35, 'size="2" face="Arial"> </font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, '<p><a name="Overview"><font size="2" face="Arial"><b></b></font></a><font '); dbms_lob.writeappend(clob_loc, 49, 'size="2" face="Arial"><b>Overview</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 65, '<p><font size="2" face="Arial">This report allows the Lineage or '); dbms_lob.writeappend(clob_loc, 70, 'Impact Analysis of an object to be displayed graphically.</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<p><font size="2" face="Arial">The Lineage of an object is '); dbms_lob.writeappend(clob_loc, 61, 'defined by the various transformation steps that are applied '); dbms_lob.writeappend(clob_loc, 64, 'before it is given a value. The Impact Analysis of an object is '); dbms_lob.writeappend(clob_loc, 59, 'defined by the various transformation steps its value goes '); dbms_lob.writeappend(clob_loc, 58, 'through as the data is transformed and used by subsequent '); dbms_lob.writeappend(clob_loc, 14, 'objects. <br> '); dbms_lob.writeappend(clob_loc, 19, ' </font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 73, '<p><a name="RepeatedObject"><font size="2" face="Arial"></font></a><font '); dbms_lob.writeappend(clob_loc, 57, 'size="2" face="Arial"><b>Repeated Objects</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 62, '<p><font size="2" face="Arial">An object may sometimes appear '); dbms_lob.writeappend(clob_loc, 66, 'twice on a diagram. Where this happens, the Lineage/ Impact '); dbms_lob.writeappend(clob_loc, 63, 'Analysis is displayed for the first occurrence only. All '); dbms_lob.writeappend(clob_loc, 66, 'subsequent occurrences of the object have their names prefixed by '); dbms_lob.writeappend(clob_loc, 63, 'an asterix (*) to indicate that they are expanded elsewhere on '); dbms_lob.writeappend(clob_loc, 18, 'the diagram. <br> '); dbms_lob.writeappend(clob_loc, 19, ' </font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, '<p><a name="DisplayOptions"><font size="2" face="Arial"><b></b></font></a><font '); dbms_lob.writeappend(clob_loc, 56, 'size="2" face="Arial"><b>Display Options</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<p><font size="2" face="Arial">The diagram has two display '); dbms_lob.writeappend(clob_loc, 66, 'options - zoom and depth. The values that you set for these '); dbms_lob.writeappend(clob_loc, 63, 'options are maintained for your login session, and so the next '); dbms_lob.writeappend(clob_loc, 58, 'diagram that you generate will use the same settings.<br> '); dbms_lob.writeappend(clob_loc, 19, ' </font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 31, '<table border="0" width="719"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 88, ' <td valign="top" width="64"><font size="2" face="Arial"><b>Zoom</b></font></td> '); dbms_lob.writeappend(clob_loc, 66, ' <td width="641"><font size="2" face="Arial">Select a zoom '); dbms_lob.writeappend(clob_loc, 65, ' value from the Zoom drop down list to redraw the diagram '); dbms_lob.writeappend(clob_loc, 55, ' using the chosen scale percentage.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 35, ' <td width="64"> </td> '); dbms_lob.writeappend(clob_loc, 36, ' <td width="641"> </td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 89, ' <td valign="top" width="64"><font size="2" face="Arial"><b>Depth</b></font></td> '); dbms_lob.writeappend(clob_loc, 61, ' <td width="641"><font size="2" face="Arial">Select a '); dbms_lob.writeappend(clob_loc, 61, ' depth value from the Depth drop down to restrict the '); dbms_lob.writeappend(clob_loc, 66, ' number of levels that are displayed in the diagram. '); dbms_lob.writeappend(clob_loc, 65, ' This is particularly useful if you have a large diagram, '); dbms_lob.writeappend(clob_loc, 64, ' but are only concerned with the first few levels. '); dbms_lob.writeappend(clob_loc, 64, ' When the diagram is redrawn, any levels below the '); dbms_lob.writeappend(clob_loc, 65, ' chosen depth are hidden. Objects that have further '); dbms_lob.writeappend(clob_loc, 64, ' hidden dependents have ellipsis (...) following them to '); dbms_lob.writeappend(clob_loc, 63, ' indicate that they have dependents. A warning is '); dbms_lob.writeappend(clob_loc, 65, ' also given that the diagram is not complete.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 76, '<p><a name="Navigation"><font size="2" face="Arial"><b></b></font></a><font '); dbms_lob.writeappend(clob_loc, 51, 'size="2" face="Arial"><b>Navigation</b></font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<p><font size="2" face="Arial">Actions may be performed by '); dbms_lob.writeappend(clob_loc, 42, 'clicking on an object image or name. <br> '); dbms_lob.writeappend(clob_loc, 19, ' </font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 31, '<table border="0" width="720"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 78, ' <td valign="top" width="123"><font size="2" face="Arial"><b>Navigator '); dbms_lob.writeappend(clob_loc, 29, ' Page</b></font></td> '); dbms_lob.writeappend(clob_loc, 61, ' <td width="583"><font size="2" face="Arial">Click an '); dbms_lob.writeappend(clob_loc, 48, ' object''s name to display it''s </font><a '); dbms_lob.writeappend(clob_loc, 84, ' href="@nav_main.html"><font size="2" face="Arial">Navigator</font></a><font '); dbms_lob.writeappend(clob_loc, 48, ' size="2" face="Arial"> page</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 36, ' <td width="123"> </td> '); dbms_lob.writeappend(clob_loc, 36, ' <td width="583"> </td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 76, ' <td valign="top" width="123"><font size="2" face="Arial"><b>Refocus '); dbms_lob.writeappend(clob_loc, 32, ' Diagram</b></font></td> '); dbms_lob.writeappend(clob_loc, 61, ' <td width="583"><font size="2" face="Arial">Click an '); dbms_lob.writeappend(clob_loc, 66, ' object''s image to redraw the diagram to show the Lineage/ '); dbms_lob.writeappend(clob_loc, 61, ' Impact Analysis for the selected object.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 36, '<p><font size="2" face="Arial"><br> '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 12, '</font></p> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/nav_lnks.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_lnks.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_lnks.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 45, '<meta name="Author" content="Geoff Watters"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 35, '<title>Navigator Links Tab</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 59, '<p><font face="Arial Black">Navigator Links Tab</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 58, '<p><font size="2" face="Arial">The Links tab displays the '); dbms_lob.writeappend(clob_loc, 66, 'external links available for the current item and user. <br> '); dbms_lob.writeappend(clob_loc, 12, '</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 62, ' <td width="24%"><font size="2" face="Arial"><b>Column '); dbms_lob.writeappend(clob_loc, 29, ' Name</b></font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="76%"><font size="2" face="Arial"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 69, ' <td width="24%"><font size="2" face="Arial">Name</font></td> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="76%"><font size="2" face="Arial">The name of '); dbms_lob.writeappend(clob_loc, 30, ' the Link.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="24%"><font size="2" face="Arial">Actions</font></td> '); dbms_lob.writeappend(clob_loc, 65, ' <td width="76%"><font size="2" face="Arial">Click on the '); dbms_lob.writeappend(clob_loc, 58, ' view action link to display the link.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font size="2" face="Arial">The other tabs in the </font><a '); dbms_lob.writeappend(clob_loc, 76, 'href="@nav_main.html"><font size="2" face="Arial">Navigator</font></a><font '); dbms_lob.writeappend(clob_loc, 68, 'size="2" face="Arial"> allow you to navigate and view the </font><a '); dbms_lob.writeappend(clob_loc, 78, 'href="@nav_prpts.html"><font size="2" face="Arial">properties</font></a><font '); dbms_lob.writeappend(clob_loc, 62, 'size="2" face="Arial">, </font><a href="@nav_cnts.html"><font '); dbms_lob.writeappend(clob_loc, 56, 'size="2" face="Arial">contents</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 63, 'face="Arial">, and </font><a href="@nav_rltd.html"><font '); dbms_lob.writeappend(clob_loc, 60, 'size="2" face="Arial">related item</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 72, 'face="Arial"> details that are applicable to the current object.</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 8, '<p><br> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/nav_main.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_main.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_main.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 51, '<title>Warehouse Builder Browser Navigator</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 84, '<p><font face="Arial Black" size="3">Warehouse Builder Browser Navigator</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 72, 'Use the Navigator to navigate around and view reports based on metadata '); dbms_lob.writeappend(clob_loc, 88, 'in an Warehouse Builder Repository. Each page displays information specific to a single '); dbms_lob.writeappend(clob_loc, 82, 'object in the Repository. This object is called the <i>current object</i>.</font> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">The Navigator page is divided into the following '); dbms_lob.writeappend(clob_loc, 32, 'parts from the top down:</font> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 69, '<a href="#Header"><font face="Arial" size="2">Header</font></a></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 80, '<a href="#Item Def"><font face="Arial" size="2">Item Definition</font></a></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 81, '<a href="#Item Details"><font face="Arial" size="2">Item Details</font></a></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 19, '<font size="2"><b> '); dbms_lob.writeappend(clob_loc, 22, '<a name="Header"></a> '); dbms_lob.writeappend(clob_loc, 57, '<font face="Arial" size="2">Header</font></b></font></p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 69, 'The header defines the type of page you are looking at and has links '); dbms_lob.writeappend(clob_loc, 29, 'to other pages. </font> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 42, 'The header contains the following:</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="697" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 66, '<td width="98"><font face="Arial" size="2">Page Title</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 118, '<td width="583"><font face="Arial" size="2">The title lets you know the type of page you are looking at. For example, '); dbms_lob.writeappend(clob_loc, 75, 'in this case you are looking at a Warehouse Builder Navigation page. There '); dbms_lob.writeappend(clob_loc, 75, 'are also Warehouse Builder Administration and Favorites pages.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 77, '<td width="98"><font face="Arial" size="2">The <u> Home</u> Link</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 103, '<td width="583"><font face="Arial" size="2">This link takes you to your default home page.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 64, '<td width="98"><font face="Arial" size="2">The Date</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 113, '<td width="583"><font face="Arial" size="2">The date shows you when the page is displayed. This is typically the '); dbms_lob.writeappend(clob_loc, 71, 'current date. If you print a report, this can be helpful to keep track '); dbms_lob.writeappend(clob_loc, 40, 'of when the report was run.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 75, '<td width="98"><font face="Arial" size="2">Add To My Favorites</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, '<td width="583"><font face="Arial" size="2">Select this link to add the current Navigation page to your Favorites '); dbms_lob.writeappend(clob_loc, 19, 'pages.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 75, '<td width="98"><font face="Arial" size="2">Browse My Favorites</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 115, '<td width="583"><font face="Arial" size="2">Select this link to view the page containing your favorite Navigations '); dbms_lob.writeappend(clob_loc, 25, 'and Reports.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 65, '<td width="98"><font face="Arial" size="2">Customize</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 84, '<td width="583"><font face="Arial" size="2">Select this link to go to the Customize '); dbms_lob.writeappend(clob_loc, 68, ' Display Options page and customize your page display.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 62, '<td width="98"><font face="Arial" size="2">Logout</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 102, '<td width="583"><font face="Arial" size="2">Select this link to log out of Oracle Portal.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 19, '<font size="2"><b> '); dbms_lob.writeappend(clob_loc, 24, '<a name="Item Def"></a> '); dbms_lob.writeappend(clob_loc, 66, '<font face="Arial" size="2">Item Definition</font></b></font></p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 71, 'The Item Definition gives you the information you need to identify the '); dbms_lob.writeappend(clob_loc, 26, 'item and its type.</font> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 51, 'The item definition contains the following:</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="694" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 69, '<td width="97"><font face="Arial" size="2">The Item Name</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 111, '<td width="581"><font face="Arial" size="2">The name of the item that you have navigated to. </font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 64, '<td width="97"><font face="Arial" size="2">The Path</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, '<td width="581"><font face="Arial" size="2">The Path shows you the context of the item. It lists the items in the '); dbms_lob.writeappend(clob_loc, 110, 'hierarchy and also shows the type of each item. For example, Path: <u>* Warehouse Builder: Repository</u>> '); dbms_lob.writeappend(clob_loc, 149, ' My Project: Project, would be the path for the project named My Project as the current item. You can click on any of the items in the path to make '); dbms_lob.writeappend(clob_loc, 35, 'that the current item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 64, '<td width="97"><font face="Arial" size="2">The Role</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 101, '<td width="581"><font face="Arial" size="2">The role that you are logged in as is shown.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 60, '<td width="97"><font face="Arial" size="2">Help</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 123, '<td width="581"><font face="Arial" size="2">The Help link will take you to online help for the Navigation Page</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 19, '<font size="2"><b> '); dbms_lob.writeappend(clob_loc, 28, '<a name="Item Details"></a> '); dbms_lob.writeappend(clob_loc, 63, '<font face="Arial" size="2">Item Details</font></b></font></p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 68, 'The Item Details section consists of a Tabbed Table. The Table will '); dbms_lob.writeappend(clob_loc, 79, 'show different information depending on which tab is currently selected. The ? '); dbms_lob.writeappend(clob_loc, 79, 'in the header of the tabbed table takes you to specific help for the currently '); dbms_lob.writeappend(clob_loc, 21, 'selected tab.</font> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 53, 'The item details contains the following tabs:</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="694" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 96, '<td width="97"><a href="@nav_prpts.html"><font face="Arial" size="2">Properties</font></a></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, '<td width="581"><font face="Arial" size="2">The Properties tab displays property name-value pairs of the selected '); dbms_lob.writeappend(clob_loc, 72, 'Item. The property names will be different depending on the type of the '); dbms_lob.writeappend(clob_loc, 26, 'current item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 93, '<td width="97"><a href="@nav_cnts.html"><font face="Arial" size="2">Contents</font></a></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 115, '<td width="581"><font face="Arial" size="2">The Contents Tab lists the Items that are contained within the current '); dbms_lob.writeappend(clob_loc, 74, 'item. For example, if the current item was a table, then the Contents Tab '); dbms_lob.writeappend(clob_loc, 72, 'would list its columns, keys and foreign keys. This is the tab that you '); dbms_lob.writeappend(clob_loc, 91, 'use when you are drilling down into the Warehouse Builder Repository by using the Contents '); dbms_lob.writeappend(clob_loc, 43, 'Action on an item in the list.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 92, '<td width="97"><a href="@nav_rltd.html"><font face="Arial" size="2">Related</font></a></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 112, '<td width="581"><font face="Arial" size="2">The Related Tab allows you to view relationships between items. For '); dbms_lob.writeappend(clob_loc, 73, 'example, if the current item is a table, then you can use it to identify '); dbms_lob.writeappend(clob_loc, 72, 'which tables it is related to with foreign keys. Like the Contents Tab, '); dbms_lob.writeappend(clob_loc, 74, 'you can use this Tab to drill down into items in the repository. When you '); dbms_lob.writeappend(clob_loc, 76, 'make one of these items the current item, the path will switch to represent '); dbms_lob.writeappend(clob_loc, 39, 'the path of this new item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 92, '<td width="97"><a href="@nav_rpts.html"><font face="Arial" size="2">Reports</font></a></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 114, '<td width="581"><font face="Arial" size="2">The Reports Tab shows you the available reports for the current item. '); dbms_lob.writeappend(clob_loc, 73, 'Each role has its own set of reports available for each item type, so if '); dbms_lob.writeappend(clob_loc, 71, 'you are a Warehouse User, you will see a different set of reports from '); dbms_lob.writeappend(clob_loc, 34, 'a Warehouse Engineer.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 90, '<td width="97"><a href="@nav_lnks.html"><font face="Arial" size="2">Links</font></a></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 78, '<td width="581"><font face="Arial" size="2">The Links Tab shows you a list of '); dbms_lob.writeappend(clob_loc, 77, ' available external items related to the current object. These items do not '); dbms_lob.writeappend(clob_loc, 73, ' exist in the Warehouse Builder Repository. They are hypertext links to '); dbms_lob.writeappend(clob_loc, 71, ' information stored within a Oracle Portal content area. </font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 9, '<center> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 10, '</center> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.close(clob_loc); --text document 'us/nav_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 51, '<title>Warehouse Builder Navigator Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial Black" size="3">Warehouse Builder Navigator Portlet</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 128, '<p><font size="2" face="Arial">Use the Warehouse Builder Navigator Portlet to browse the repositories accessible to the current '); dbms_lob.writeappend(clob_loc, 81, 'user within the area assigned to the portlet. The Navigator Portlet has the same '); dbms_lob.writeappend(clob_loc, 95, 'functionality as the Navigator, except it continues to display within the area of the portlet. '); dbms_lob.writeappend(clob_loc, 84, 'You can click the <u>Full Page</u> link to display the Navigator. </font></p> '); dbms_lob.writeappend(clob_loc, 80, '<p><font size="2" face="Arial">The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 81, 'links available on this portlet. Select the question mark on each tab to display '); dbms_lob.writeappend(clob_loc, 69, 'specific information about each Navigator tab area. </font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 49, ' <table border="1" width="516" cellspacing="1"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="155" valign="top" align="left"><b><font size="2" face="Arial">Action '); dbms_lob.writeappend(clob_loc, 29, ' Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="345" valign="top" align="left"><b><font size="2" face="Arial">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 98, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">Customize</font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="345" valign="top" align="left"><font face="Arial" size="2">Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 93, ' <td valign="top" align="left" width="155"><font size="2" face="Arial">Help</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="345" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 94, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">About</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="345" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 80, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">Add '); dbms_lob.writeappend(clob_loc, 36, ' to My Favorites</font></td> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="345" valign="top" align="left"><font face="Arial" size="2">Adds '); dbms_lob.writeappend(clob_loc, 70, ' the current Navigator page to the Favorites page.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="155" valign="top" align="left"><font face="Arial" size="2">Full '); dbms_lob.writeappend(clob_loc, 25, ' Page</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="345" valign="top" align="left"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' </table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_port_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_port_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_port_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 43, '<title>Customizing Display Options</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<font face="Arial Black">Customizing Display Options</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">Use the Customize Display Options page to set up '); dbms_lob.writeappend(clob_loc, 86, 'the Navigator portlet. There are two sets of options for you to set. </font></p> '); dbms_lob.writeappend(clob_loc, 64, '<p><b><font face="Arial" size="2">Role Selection</font></b></p> '); dbms_lob.writeappend(clob_loc, 53, '<p><font face="Arial"><font size="2">Select the role '); dbms_lob.writeappend(clob_loc, 77, 'you want to use with the Navigator. These roles are defined in the following '); dbms_lob.writeappend(clob_loc, 91, 'table. Use the Administration pages to assign access to roles. The default is <i>Warehouse '); dbms_lob.writeappend(clob_loc, 28, 'User</i>.</font></font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="89%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="28%"><b><font face="Arial" size="2">Role</font></b></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="72%"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 80, ' <td width="28%"><font SIZE="2" face="Arial">Warehouse Developer</font></td> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="72%"><font SIZE="2" face="Arial">User that uses Warehouse Builder '); dbms_lob.writeappend(clob_loc, 43, ' to create the warehouse.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 74, ' <td width="28%"><font SIZE="2" face="Arial">QA User </font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="72%"><font SIZE="2" face="Arial">User that tests the quality of '); dbms_lob.writeappend(clob_loc, 55, ' the warehouse before it is deployed.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 75, ' <td width="28%"><font SIZE="2" face="Arial">Warehouse User</font></td> '); dbms_lob.writeappend(clob_loc, 76, ' <td width="72%"><font SIZE="2" face="Arial">User that uses the deployed '); dbms_lob.writeappend(clob_loc, 67, ' Warehouse to understand the underlying metadata.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 67, '<p><b><font face="Arial" size="2">Display Selection</font></b></p> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2">Specify how many items you want displayed within '); dbms_lob.writeappend(clob_loc, 56, 'the portlet. The default is <i>Show All</i>.</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 114, ' <li><b><font face="Arial" size="2">Show All</font></b> <font face="Arial" size="2"> - displays all items within '); dbms_lob.writeappend(clob_loc, 28, ' the portlet</font></li> '); dbms_lob.writeappend(clob_loc, 69, ' <li><b><font face="Arial" size="2">Limit List to '); dbms_lob.writeappend(clob_loc, 128, ' Items</font></b> <font face="Arial" size="2"> - displays only the specified number of items within the portlet.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.close(clob_loc); --text document 'us/nav_prpts.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_prpts.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_prpts.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 63, '<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> '); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 76, ' <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 48, ' <meta name="Author" content="Geoff Watters"> '); dbms_lob.writeappend(clob_loc, 61, ' <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> '); dbms_lob.writeappend(clob_loc, 43, ' <title>Navigator Properties Tab</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 73, '<p><font face="Arial Black" size="3">Navigator Properties Tab</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 77, 'Use the Properties tab to display property names and values for the selected '); dbms_lob.writeappend(clob_loc, 77, 'item. The property names will be different depending on the item type of the '); dbms_lob.writeappend(clob_loc, 14, 'current item. '); dbms_lob.writeappend(clob_loc, 18, '<br> </font> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="476" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 75, '<td width="100"><b><font face="Arial" size="2">Column Name</font></b></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 75, '<td width="360"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 70, '<td width="100"><font face="Arial" size="2">Property Name</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 87, '<td width="360"><font face="Arial" size="2">The name of the property as defined in the '); dbms_lob.writeappend(clob_loc, 46, ' Warehouse Builder Public Views.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 71, '<td width="100"><font face="Arial" size="2">Property Value</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 85, '<td width="360"><font face="Arial" size="2">The value of the property taken from the '); dbms_lob.writeappend(clob_loc, 47, ' Warehouse Builder Repository for the current '); dbms_lob.writeappend(clob_loc, 18, 'item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 92, '<p><font face="Arial" size="2">The other tabs in the <a href="@nav_main.html">Navigator</a> '); dbms_lob.writeappend(clob_loc, 107, 'allow you to navigate and view the <a href="@nav_cnts.html">contents</a>, <a href="@nav_rltd.html">related '); dbms_lob.writeappend(clob_loc, 109, 'items</a>, <a href="@nav_rpts.html">reports</a>, and links that are applicable to the current object.</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 5, '<br> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/nav_rfsh_di.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_rfsh_di.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_rfsh_di.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 47, '<title>Refreshing the Dependency Index</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 71, '<p><font face="Arial Black">Refreshing the Dependency Index</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 81, '<p><font class="PortletText2" size="2" face="Arial">The Dependency Index is used '); dbms_lob.writeappend(clob_loc, 80, 'when displaying Lineage and Impact Analysis diagrams. In order for the diagrams '); dbms_lob.writeappend(clob_loc, 102, 'to display the most current information, the index must be refreshed regularly, if the content of the '); dbms_lob.writeappend(clob_loc, 37, 'repository is not frozen.</font></p> '); dbms_lob.writeappend(clob_loc, 84, '<p><font face="Arial" size="2">Select one of the following action links:</font></p> '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 74, ' <td width="33%"><font face="Arial" size="2"><b>Action</b></font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="67%"><font face="Arial" size="2"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 91, ' <td width="33%"><u><font class="PortletText2" size="2" face="Arial">Refresh Dependency '); dbms_lob.writeappend(clob_loc, 28, ' Index</font></u></td> '); dbms_lob.writeappend(clob_loc, 143, ' <td width="67%"><font class="PortletText2" size="2" face="Arial">Refreshes the dependency index based on the latest data in the repository '); dbms_lob.writeappend(clob_loc, 79, 'and stores the username, date, and elapsed time in a log. The log is displayed '); dbms_lob.writeappend(clob_loc, 44, 'on the lower half of this page.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 78, ' <td width="33%"><u><font class="PortletText2" size="2" face="Arial">Purge '); dbms_lob.writeappend(clob_loc, 26, ' Log</font></u></td> '); dbms_lob.writeappend(clob_loc, 152, ' <td width="67%"><font class="PortletText2" size="2" face="Arial">Purges the log of refreshes performed. The last refresh will be saved.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/nav_rltd.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_rltd.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_rltd.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 63, '<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> '); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 76, ' <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 48, ' <meta name="Author" content="Geoff Watters"> '); dbms_lob.writeappend(clob_loc, 61, ' <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> '); dbms_lob.writeappend(clob_loc, 40, ' <title>Navigator Related Tab</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 61, '<p><font face="Arial Black">Navigator Related Tab</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 78, '<font face="Arial" size="2">Use the Related tab to view relationships between '); dbms_lob.writeappend(clob_loc, 72, 'items. For example, if the current item is a table, then you can use it '); dbms_lob.writeappend(clob_loc, 115, 'to identify which tables it has foreign keys to. Use this tab to drill down into items in the repository. When you '); dbms_lob.writeappend(clob_loc, 76, 'make one of these items the current item, the path will switch to represent '); dbms_lob.writeappend(clob_loc, 40, 'the path of this new item. </font> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2"> The following table describes the Related tab '); dbms_lob.writeappend(clob_loc, 26, 'column values.</font></p> '); dbms_lob.writeappend(clob_loc, 32, '<table BORDER="1" WIDTH="535" > '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 82, '<td valign="top" align="left" width="103"><b><font face="Arial" size="2">Physical '); dbms_lob.writeappend(clob_loc, 23, ' Name</font></b></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 101, '<td valign="top" align="left" width="416"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 87, '<td valign="top" align="left" width="103"><font face="Arial" size="2">Name</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 74, '<td valign="top" align="left" width="416"><font face="Arial" size="2">The '); dbms_lob.writeappend(clob_loc, 41, ' physical name of the item.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 87, '<td valign="top" align="left" width="103"><font face="Arial" size="2">Type</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 133, '<td valign="top" align="left" width="416"><font face="Arial" size="2">An icon showing a graphical representation of the of item type '); dbms_lob.writeappend(clob_loc, 38, ' and the item type name.</font></td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<tr> '); dbms_lob.writeappend(clob_loc, 89, '<td valign="top" align="left" width="98"><font face="Arial" size="2">Actions</font></td> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 80, '<td valign="top" align="left" width="352"><font face="Arial" size="2">There are '); dbms_lob.writeappend(clob_loc, 75, ' two types of actions: generic actions and item specific actions. Generic '); dbms_lob.writeappend(clob_loc, 77, ' actions are available for every item and are intended to help navigate the '); dbms_lob.writeappend(clob_loc, 79, ' repository. Item specific actions are only available for particular items or '); dbms_lob.writeappend(clob_loc, 71, ' item types and either perform tasks or link to external data.</font> '); dbms_lob.writeappend(clob_loc, 68, ' <p><font face="Arial" size="2"><b>Generic Actions:</b></font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 50, '<font size="2" face="Arial">properties</font></u> '); dbms_lob.writeappend(clob_loc, 53, '<font size="2" face="Arial"> - selecting this action '); dbms_lob.writeappend(clob_loc, 44, 'link makes the item on that row the current '); dbms_lob.writeappend(clob_loc, 83, 'item and takes you straight to the Properties tab for that item. </font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 48, '<font size="2" face="Arial">contents</font></u> '); dbms_lob.writeappend(clob_loc, 53, '<font size="2" face="Arial"> - selecting this action '); dbms_lob.writeappend(clob_loc, 44, 'link makes the item on that row the current '); dbms_lob.writeappend(clob_loc, 75, 'item and takes you straight to the Contents tab for that item.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 47, '<font size="2" face="Arial">related</font></u> '); dbms_lob.writeappend(clob_loc, 53, '<font size="2" face="Arial"> - selecting this action '); dbms_lob.writeappend(clob_loc, 44, 'link makes the item on that row the current '); dbms_lob.writeappend(clob_loc, 74, 'item and takes you straight to the Related tab for that item.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 47, '<font size="2" face="Arial">reports</font></u> '); dbms_lob.writeappend(clob_loc, 53, '<font size="2" face="Arial"> - selecting this action '); dbms_lob.writeappend(clob_loc, 44, 'link makes the item on that row the current '); dbms_lob.writeappend(clob_loc, 79, 'item and take you straight to the Reports tab for that item. </font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 45, '<font size="2" face="Arial">links</font></u> '); dbms_lob.writeappend(clob_loc, 29, '<font size="2" face="Arial"> '); dbms_lob.writeappend(clob_loc, 77, '- selecting this action link makes the item on that row the current item and '); dbms_lob.writeappend(clob_loc, 63, 'takes you straight to the Links tab for that item.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 6, ' <p> '); dbms_lob.writeappend(clob_loc, 31, ' <font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 70, 'Note: You can also use <u>contents</u> to select a new item and '); dbms_lob.writeappend(clob_loc, 87, 'then switch tabs when the screen has refreshed. The <u>properties</u>, <u>related</u>, '); dbms_lob.writeappend(clob_loc, 71, '<u>reports</u> and <u>links</u> action links are shortcuts.</font></p> '); dbms_lob.writeappend(clob_loc, 74, ' <p><font size="2" face="Arial"><b>Item Specific Actions:</b></font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 4, '<u> '); dbms_lob.writeappend(clob_loc, 64, '<font size="2" face="Arial">refresh dependency index</font></u> '); dbms_lob.writeappend(clob_loc, 29, '<font size="2" face="Arial"> '); dbms_lob.writeappend(clob_loc, 77, '- selecting this action link takes you to the Refresh Dependency Index page. '); dbms_lob.writeappend(clob_loc, 61, 'This action link only displays for Repositories.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 77, '<font size="2" face="Arial">External links can also display as item specific '); dbms_lob.writeappend(clob_loc, 81, 'actions. Specify which items should be affiliated with each link when you define '); dbms_lob.writeappend(clob_loc, 31, 'the external link.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 8, ' </td> '); dbms_lob.writeappend(clob_loc, 6, '</tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 92, '<p><font face="Arial" size="2">The other tabs in the <a href="@nav_main.html">Navigator</a> '); dbms_lob.writeappend(clob_loc, 110, 'allow you to navigate and view the <a href="@nav_prpts.html">properties</a>, <a href="@nav_rltd.html">related '); dbms_lob.writeappend(clob_loc, 82, 'items</a>, <a href="@nav_rpts.html">reports</a>, and links that are applicable to '); dbms_lob.writeappend(clob_loc, 27, 'the current object.</font> '); dbms_lob.writeappend(clob_loc, 18, '<hr WIDTH="100%"> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 15, '<br> </p> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/nav_rpts.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('nav_rpts.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'nav_rpts.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 7, '<html> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 32, '<meta http-equiv="Content-Type" '); dbms_lob.writeappend(clob_loc, 41, 'content="text/html; charset=iso-8859-1"> '); dbms_lob.writeappend(clob_loc, 45, '<meta name="Author" content="Geoff Watters"> '); dbms_lob.writeappend(clob_loc, 66, '<meta name="GENERATOR" content="Microsoft FrontPage Express 2.0"> '); dbms_lob.writeappend(clob_loc, 37, '<title>Navigator Reports Tab</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<body> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 61, '<p><font face="Arial Black">Navigator Reports Tab</font></p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<p><font size="2" face="Arial">The Reports tab displays the '); dbms_lob.writeappend(clob_loc, 62, 'Reports available for the current item. Select <u>view</u> to '); dbms_lob.writeappend(clob_loc, 66, 'open up the Report for each related object. Each role has its own '); dbms_lob.writeappend(clob_loc, 61, 'set of Reports available for each item type, so if you are a '); dbms_lob.writeappend(clob_loc, 65, 'Business User, you will see a different set of reports from a QA '); dbms_lob.writeappend(clob_loc, 11, 'user. <br> '); dbms_lob.writeappend(clob_loc, 19, ' </font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="452"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 62, ' <td width="104"><font size="2" face="Arial"><b>Column '); dbms_lob.writeappend(clob_loc, 29, ' Name</b></font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="332"><font size="2" face="Arial"><b>Description</b></font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 69, ' <td width="104"><font size="2" face="Arial">Name</font></td> '); dbms_lob.writeappend(clob_loc, 64, ' <td width="332"><font size="2" face="Arial">The name of '); dbms_lob.writeappend(clob_loc, 32, ' the report.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 72, ' <td width="104"><font size="2" face="Arial">Actions</font></td> '); dbms_lob.writeappend(clob_loc, 78, ' <td width="332"><font size="2" face="Arial">Click <u>view</u> to '); dbms_lob.writeappend(clob_loc, 40, ' display the report.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font size="2" face="Arial">For information about </font><a '); dbms_lob.writeappend(clob_loc, 61, 'href="@nav_lia.html"><font size="2" face="Arial">Lineage and '); dbms_lob.writeappend(clob_loc, 62, 'Impact Analysis diagrams, click here</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 27, 'face="Arial">.</font> </p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><font size="2" face="Arial">The other tabs in the </font><a '); dbms_lob.writeappend(clob_loc, 76, 'href="@nav_main.html"><font size="2" face="Arial">Navigator</font></a><font '); dbms_lob.writeappend(clob_loc, 68, 'size="2" face="Arial"> allow you to navigate and view the </font><a '); dbms_lob.writeappend(clob_loc, 78, 'href="@nav_prpts.html"><font size="2" face="Arial">properties</font></a><font '); dbms_lob.writeappend(clob_loc, 62, 'size="2" face="Arial">, </font><a href="@nav_cnts.html"><font '); dbms_lob.writeappend(clob_loc, 56, 'size="2" face="Arial">contents</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 69, 'face="Arial">, links and </font><a href="@nav_rltd.html"><font '); dbms_lob.writeappend(clob_loc, 60, 'size="2" face="Arial">related item</font></a><font size="2" '); dbms_lob.writeappend(clob_loc, 72, 'face="Arial"> details that are applicable to the current object.</font> '); dbms_lob.writeappend(clob_loc, 5, '</p> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 8, '</body> '); dbms_lob.writeappend(clob_loc, 8, '</html> '); dbms_lob.close(clob_loc); --text document 'us/rpt_port.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rpt_port.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rpt_port.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 49, '<title>Warehouse Builder Reports Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 82, '<p><font face="Arial Black" size="3">Warehouse Builder Reports Portlet</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 76, '<p><font face="Arial" size="2">Use the Warehouse Builder Reports Portlet to '); dbms_lob.writeappend(clob_loc, 77, 'display a Warehouse Builder Report on your Oracle Portal home page. When you '); dbms_lob.writeappend(clob_loc, 82, 'install this portlet, it does not contain a default Report. In order to display a '); dbms_lob.writeappend(clob_loc, 82, 'Report, you must add a report to your favorites. Once the report is saved in your '); dbms_lob.writeappend(clob_loc, 86, 'favorites you can use the <u>Customize</u> link on this portlet to add it.</font></p> '); dbms_lob.writeappend(clob_loc, 85, '<p><font face="Arial" size="2"><b>NOTE:</b> When you have a Reports portlet on '); dbms_lob.writeappend(clob_loc, 79, 'your Oracle Portal home page, it refreshes each time you reload the home page. '); dbms_lob.writeappend(clob_loc, 45, 'This can delay the page display. </font></p> '); dbms_lob.writeappend(clob_loc, 80, '<p><font size="2" face="Arial">The following table describes some of the action '); dbms_lob.writeappend(clob_loc, 44, 'links available on this portlet.</font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 49, ' <table border="1" width="515" cellspacing="1"> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 86, ' <td width="155" valign="top" align="left"><b><font size="2" face="Arial">Action '); dbms_lob.writeappend(clob_loc, 29, ' Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="344" valign="top" align="left"><b><font size="2" face="Arial">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 98, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">Customize</font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Allows '); dbms_lob.writeappend(clob_loc, 59, ' you to customize your display options.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 93, ' <td valign="top" align="left" width="155"><font size="2" face="Arial">Help</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 54, ' the online help for this portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 94, ' <td valign="top" align="left" width="155"><font face="Arial" size="2">About</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font face="Arial" size="2">Displays '); dbms_lob.writeappend(clob_loc, 69, ' information about the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, ' <tr> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="155" valign="top" align="left"><font face="Arial" size="2">Full '); dbms_lob.writeappend(clob_loc, 25, ' Page</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="344" valign="top" align="left"><font size="2" face="Arial">Displays '); dbms_lob.writeappend(clob_loc, 53, ' the Navigator in full page mode.</font></td> '); dbms_lob.writeappend(clob_loc, 10, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' </table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.writeappend(clob_loc, 7, ' '); dbms_lob.close(clob_loc); --text document 'us/rpt_port_cst.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rpt_port_cst.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rpt_port_cst.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 47, '<title>Customizing the Reports Portlet</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 73, '<font face="Arial Black" size="3">Customizing the Reports Portlet</font> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 85, '<p><font face="Arial" size="2">Use the Reports Customize page to select which report '); dbms_lob.writeappend(clob_loc, 78, 'to display in the Reports portlet. You can only choose from Reports that have '); dbms_lob.writeappend(clob_loc, 60, 'previously been added to your list of favorites.</font></p> '); dbms_lob.writeappend(clob_loc, 80, '<p><font face="Arial" size="2"><b>To add a Report to the portal:</b></font></p> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2">Choose the Report you want displayed and click '); dbms_lob.writeappend(clob_loc, 64, 'the <u>Make Default</u> link from the Actions column. <br> '); dbms_lob.writeappend(clob_loc, 29, ' The link will change to <u> '); dbms_lob.writeappend(clob_loc, 83, 'Reset Default</u>. If you have more than one Report available, only one can be set '); dbms_lob.writeappend(clob_loc, 52, 'as the default in the portlet at a time.</font></p> '); dbms_lob.writeappend(clob_loc, 78, '<p><font face="Arial" size="2">You can also choose to not display a Report in '); dbms_lob.writeappend(clob_loc, 79, 'the portlet. This is beneficial if you have a large report in your portlet and '); dbms_lob.writeappend(clob_loc, 81, 'you are reloading the Oracle Portal home page frequently. </font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgmt.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgmt.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgmt.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 34, '<title>Managing Resources</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 58, '<p><font face="Arial Black">Managing Resources</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 81, '<p><font face="Arial" size="2">Use the Resource Management page to set up access '); dbms_lob.writeappend(clob_loc, 80, 'to different Warehouse Builder Browser elements, as well as edit and unregister '); dbms_lob.writeappend(clob_loc, 27, 'repositories. </font> '); dbms_lob.writeappend(clob_loc, 79, '<p><font face="Arial" size="2">The following table describes available actions '); dbms_lob.writeappend(clob_loc, 35, 'for each resource type:</font></p> '); dbms_lob.writeappend(clob_loc, 19, '<div align="left"> '); dbms_lob.writeappend(clob_loc, 62, ' <table border="1" cellSpacing="1" width="515" height="349"> '); dbms_lob.writeappend(clob_loc, 12, ' <tbody> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 102, ' <td width="17%" valign="top" align="left" height="32"><b><font face="Arial" size="2">Resource '); dbms_lob.writeappend(clob_loc, 31, ' Type</font></b></td> '); dbms_lob.writeappend(clob_loc, 100, ' <td width="22%" valign="top" align="left" height="32"><b><font face="Arial" size="2">Action '); dbms_lob.writeappend(clob_loc, 31, ' Link</font></b></td> '); dbms_lob.writeappend(clob_loc, 121, ' <td width="99%" valign="top" align="left" height="32"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 110, ' <td width="17%" valign="top" align="left" height="16"><font face="Arial" size="2">Portlet</font></td> '); dbms_lob.writeappend(clob_loc, 109, ' <td width="22%" valign="top" align="left" height="16"><font face="Arial" size="2">Access</font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="16"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 67, ' this to grant or revoke access to a portlet.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 125, ' <td width="17%" rowspan="3" valign="top" align="left" height="99"><font face="Arial" size="2">Repository</font></td> '); dbms_lob.writeappend(clob_loc, 109, ' <td width="22%" valign="top" align="left" height="25"><font face="Arial" size="2">Access</font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="25"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 70, ' this to grant or revoke access to a repository.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 113, ' <td width="22%" valign="top" align="left" height="14"><font face="Arial" size="2">Edit </font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="14"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 62, ' this to edit repository specifications.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 119, ' <td width="22%" valign="top" align="left" height="48"><font face="Arial" size="2">Unregister </font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="48"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 110, ' this to unregister a repository. After unregistration the repository can no longer be browsed using '); dbms_lob.writeappend(clob_loc, 43, 'the Warehouse Builder Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="17%" valign="top" align="left" height="32"><font face="Arial" size="2">Role</font></td> '); dbms_lob.writeappend(clob_loc, 109, ' <td width="22%" valign="top" align="left" height="32"><font face="Arial" size="2">Access</font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="32"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 64, ' this to grant or revoke access to a role.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 110, ' <td width="17%" rowspan="3" valign="top" align="left" height="140"><font face="Arial" size="2">Custom '); dbms_lob.writeappend(clob_loc, 29, ' Report</font></td> '); dbms_lob.writeappend(clob_loc, 95, ' <td width="22%" valign="top" align="left" height="48"><font face="Arial" size="2">Role '); dbms_lob.writeappend(clob_loc, 17, '<br></font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="48"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 53, ' this to assign the report to one or roles. '); dbms_lob.writeappend(clob_loc, 76, 'When the report is assigned to a role, it appears in the appropriate report '); dbms_lob.writeappend(clob_loc, 32, 'list for that role.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="22%" valign="top" align="left" height="32"><font face="Arial" size="2">Edit</font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="32"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 69, ' this to edit the specification for the report.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 11, ' <tr> '); dbms_lob.writeappend(clob_loc, 113, ' <td width="22%" valign="top" align="left" height="48"><font face="Arial" size="2">Unregister</font></td> '); dbms_lob.writeappend(clob_loc, 94, ' <td width="99%" valign="top" align="left" height="48"><font face="Arial" size="2">Use '); dbms_lob.writeappend(clob_loc, 106, ' this to unregister a report. After unregistration, the report can no longer be viewed using the '); dbms_lob.writeappend(clob_loc, 28, ' Warehouse Builder '); dbms_lob.writeappend(clob_loc, 21, 'Browser.</font></td> '); dbms_lob.writeappend(clob_loc, 12, ' </tr> '); dbms_lob.writeappend(clob_loc, 13, ' </tbody> '); dbms_lob.writeappend(clob_loc, 11, ' </table> '); dbms_lob.writeappend(clob_loc, 7, '</div> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 9, '<center> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 10, '</center> '); dbms_lob.writeappend(clob_loc, 14, '<p> </p> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_ed_cr.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_ed_cr.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_ed_cr.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 38, '<title>Editing Custom Reports</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 62, '<p><font face="Arial Black">Editing Custom Reports</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 77, '<p><font face="Arial" size="2">Use the Edit a custom report page to edit the '); dbms_lob.writeappend(clob_loc, 77, 'information about custom report. A Custom Report is an application component '); dbms_lob.writeappend(clob_loc, 80, 'created using the Oracle Portal facilities. Registration of the report provides '); dbms_lob.writeappend(clob_loc, 81, 'the Warehouse Builder Browser system with the information required to invoke the '); dbms_lob.writeappend(clob_loc, 80, 'report. In order for the report to be available, roles must be assigned. If you '); dbms_lob.writeappend(clob_loc, 78, 'are editing an existing custom report, it is not necessary to re-assign roles '); dbms_lob.writeappend(clob_loc, 36, 'that previously existed.</font></p> '); dbms_lob.writeappend(clob_loc, 77, '<p><font face="Arial" size="2">The following table describes the fields that '); dbms_lob.writeappend(clob_loc, 38, 'pertain to Custom Reports.</font></p> '); dbms_lob.writeappend(clob_loc, 32, '<table border="1" width="100%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 78, ' <td width="12%"><b><font face="Arial" size="2">Field Name</font></b></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="88%"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 73, ' <td width="12%"><font face="Arial" size="2">Display Name</font></td> '); dbms_lob.writeappend(clob_loc, 85, ' <td width="88%"><font face="Arial" size="2">Edit the name of the report which is '); dbms_lob.writeappend(clob_loc, 49, ' seen in the reports list page.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 70, ' <td width="12%"><font face="Arial" size="2">Type Name</font></td> '); dbms_lob.writeappend(clob_loc, 79, ' <td width="88%"><font face="Arial" size="2">Edit the name of the data type '); dbms_lob.writeappend(clob_loc, 92, ' reported on by this report. Choose one data type from the drop-down menu.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 68, ' <td width="12%"><font face="Arial" size="2">Package</font></td> '); dbms_lob.writeappend(clob_loc, 81, ' <td width="88%"><font face="Arial" size="2">Edit the full name of the PL/SQL '); dbms_lob.writeappend(clob_loc, 56, ' package which implements this report.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 71, ' <td width="12%"><font face="Arial" size="2">Repository</font></td> '); dbms_lob.writeappend(clob_loc, 80, ' <td width="88%"><font face="Arial" size="2">Edit the name of the repository '); dbms_lob.writeappend(clob_loc, 79, ' containing target objects for this report. The drop-down menu contains a '); dbms_lob.writeappend(clob_loc, 55, ' list of the registered repositories.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 45, '<p><font face="Arial" size="2"> </font> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_ed_crrole.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_ed_crrole.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_ed_crrole.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 43, '<title>Editing Custom Report Roles</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 67, '<p><font face="Arial Black">Editing Custom Report Roles</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 103, '<font face="Arial" size="2">Use the Edit Custom Report Roles page to assign a custom report to a role. '); dbms_lob.writeappend(clob_loc, 79, 'Access to custom reports is given at the role level, not the individual level. '); dbms_lob.writeappend(clob_loc, 80, 'Custom reports will only appear if they are assigned to the role of the current '); dbms_lob.writeappend(clob_loc, 10, 'user. The '); dbms_lob.writeappend(clob_loc, 75, 'name of the report is indicated at the top left corner of the page. A list '); dbms_lob.writeappend(clob_loc, 82, 'of the available roles is provided in the table at the bottom of the page.</font> '); dbms_lob.writeappend(clob_loc, 76, '<p><b><font face="Arial" size="2">To add access to a given role:</font></b> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 70, ' <li><font face="Arial" size="2">Click <u>add</u> in the appropriate '); dbms_lob.writeappend(clob_loc, 27, ' table row.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 85, '<p><b><font face="Arial" size="2">To remove access from a given role:</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 61, ' <li><font face="Arial" size="2">Click <u>remove</u> in the '); dbms_lob.writeappend(clob_loc, 39, ' appropriate table row.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_ed_dblink.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_ed_dblink.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_ed_dblink.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 38, '<title>Editing Database Links</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 71, '<p><font face="Arial Black" size="3">Editing Database Links</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 16, '<font SIZE="2"> '); dbms_lob.writeappend(clob_loc, 74, '<p><b><font size="2" face="Arial">To edit a database link:</font></b></p> '); dbms_lob.writeappend(clob_loc, 32, '<ol style="font-family: Arial"> '); dbms_lob.writeappend(clob_loc, 75, ' <li><font size="2" face="Arial">From the Administer Database Links page, '); dbms_lob.writeappend(clob_loc, 69, ' select <u>edit</u> for the database link you want to alter. <br> '); dbms_lob.writeappend(clob_loc, 9, ' <br> '); dbms_lob.writeappend(clob_loc, 46, ' The Edit Database Link page displays.<br> '); dbms_lob.writeappend(clob_loc, 17, ' </font></li> '); dbms_lob.writeappend(clob_loc, 160, ' <li><font size="2" face="Arial">Make any edits to the database link and click <b>Apply</b>. You can continue to edit the link by applying your changes. Click '); dbms_lob.writeappend(clob_loc, 15, ' <b> OK</b> '); dbms_lob.writeappend(clob_loc, 39, ' when you are finished.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ol> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 8, '</font> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_edrep.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_edrep.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_edrep.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 36, '<title>Editing a Repository</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 60, '<p><font face="Arial Black">Editing a Repository</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 78, '<font face="Arial" size="2">Use the Edit Repository page to edit a repository '); dbms_lob.writeappend(clob_loc, 78, 'with the Warehouse Builder Browser as well as link to the Administer Database '); dbms_lob.writeappend(clob_loc, 76, 'Links page. Click <b>OK</b> to commit changes. Click <b>Cancel </b>to '); dbms_lob.writeappend(clob_loc, 24, 'discard changes.</font> '); dbms_lob.writeappend(clob_loc, 74, '<p><font face="Arial" size="2">Fill in the following fields to register a '); dbms_lob.writeappend(clob_loc, 23, 'repository:</font></p> '); dbms_lob.writeappend(clob_loc, 31, '<table border="1" width="67%"> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 104, ' <td width="20%" valign="top" align="left"><b><font face="Arial" size="2">Field Name</font></b></td> '); dbms_lob.writeappend(clob_loc, 105, ' <td width="80%" valign="top" align="left"><b><font face="Arial" size="2">Description</font></b></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 91, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">Name</font></td> '); dbms_lob.writeappend(clob_loc, 83, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The name '); dbms_lob.writeappend(clob_loc, 21, ' the repository '); dbms_lob.writeappend(clob_loc, 94, ' will be known as within the Warehouse Builder Browser system. For example, this name is '); dbms_lob.writeappend(clob_loc, 53, ' displayed in the navigation pages.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 96, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">Host Name</font></td> '); dbms_lob.writeappend(clob_loc, 102, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The name of the computer on '); dbms_lob.writeappend(clob_loc, 73, ' which the repository is stored. This name must be identical to the '); dbms_lob.writeappend(clob_loc, 75, ' name used within the Warehouse Builder client or else it will not be '); dbms_lob.writeappend(clob_loc, 83, ' possible to invoke reports for this repository from that client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 99, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">Database SID</font></td> '); dbms_lob.writeappend(clob_loc, 107, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The SID of the database in which '); dbms_lob.writeappend(clob_loc, 72, ' the repository is stored. This name must be identical to the name '); dbms_lob.writeappend(clob_loc, 79, ' used within the Warehouse Builder client or else it will not be possible '); dbms_lob.writeappend(clob_loc, 54, ' to invoke reports from that client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 108, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">OWB Repository Schema</font></td> '); dbms_lob.writeappend(clob_loc, 106, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The name of the schema in which '); dbms_lob.writeappend(clob_loc, 72, ' the repository is stored. This name must be identical to the name '); dbms_lob.writeappend(clob_loc, 79, ' used within the Warehouse Builder client or else it will not be possible '); dbms_lob.writeappend(clob_loc, 54, ' to invoke reports from that client.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 100, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">Database Link</font></td> '); dbms_lob.writeappend(clob_loc, 104, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The name of the database link '); dbms_lob.writeappend(clob_loc, 80, ' which should be used to access the repository. The link must already have '); dbms_lob.writeappend(clob_loc, 81, ' been created, using SQL*Plus for example. This field must be specified and '); dbms_lob.writeappend(clob_loc, 80, ' must refer to a valid link even if the repository is on the same database '); dbms_lob.writeappend(clob_loc, 59, ' as the Warehouse Builder Browser system.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 7, ' <tr> '); dbms_lob.writeappend(clob_loc, 98, ' <td width="20%" valign="top" align="left"><font face="Arial" size="2">Description</font></td> '); dbms_lob.writeappend(clob_loc, 101, ' <td width="80%" valign="top" align="left"><font face="Arial" size="2">The descriptive text which '); dbms_lob.writeappend(clob_loc, 75, ' appears within the navigation pages for this repository.</font></td> '); dbms_lob.writeappend(clob_loc, 8, ' </tr> '); dbms_lob.writeappend(clob_loc, 9, '</table> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_portacc.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_portacc.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_portacc.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 52, '<title>Granting and Revoking Portlet Access</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 4, '<p> '); dbms_lob.writeappend(clob_loc, 82, '<font face="Arial Black" size="3">Granting and Revoking Portlet Access</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 80, '<font face="Arial" size="2">Use this page to enable access to Warehouse Builder '); dbms_lob.writeappend(clob_loc, 95, 'portlets by granting or revoking access from Warehouse Builder Browser users and groups. '); dbms_lob.writeappend(clob_loc, 81, 'A list of the current users and groups that have been granted access is provided '); dbms_lob.writeappend(clob_loc, 35, 'under <b>Change Access</b>.</font> '); dbms_lob.writeappend(clob_loc, 70, '<p><b><font face="Arial" size="2">Grant Access To User</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 81, 'To grant an access right to a Warehouse Builder Browser user, select the name of '); dbms_lob.writeappend(clob_loc, 72, 'a user from the drop-down menu and click <b>Grant User</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 71, '<p><b><font face="Arial" size="2">Grant Access To Group</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 92, 'To grant an access right to a Warehouse Builder Browser group, select the name of the group '); dbms_lob.writeappend(clob_loc, 66, 'from the drop-down menu and click <b>Grant Group</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 63, '<p><b><font face="Arial" size="2">Change Access</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 5, '<li> '); dbms_lob.writeappend(clob_loc, 29, '<font face="Arial" size="2"> '); dbms_lob.writeappend(clob_loc, 70, 'To revoke an access right, click on <u> revoke</u> in the appropriate '); dbms_lob.writeappend(clob_loc, 23, 'table row.</font></li> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_repacc.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_repacc.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_repacc.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 55, '<title>Granting and Revoking Repository Access</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 88, '<p><font face="Arial Black" size="3">Granting and Revoking Repository Access</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 73, '<font face="Arial" size="2">Use this page to enable access to registered '); dbms_lob.writeappend(clob_loc, 99, 'repositories by granting or revoking access from Warehouse Builder Browser users and groups. '); dbms_lob.writeappend(clob_loc, 81, 'A list of the current users and groups that have been granted access is provided '); dbms_lob.writeappend(clob_loc, 35, 'under <b>Change Access</b>.</font> '); dbms_lob.writeappend(clob_loc, 70, '<p><b><font face="Arial" size="2">Grant Access To User</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 74, ' <li><font face="Arial" size="2">To grant an access right to a Warehouse '); dbms_lob.writeappend(clob_loc, 117, ' Builder Browser user, select the name of a user from the drop-down menu and click <b>Grant User</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 71, '<p><b><font face="Arial" size="2">Grant Access To Group</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 74, ' <li><font face="Arial" size="2">To grant an access right to a Warehouse '); dbms_lob.writeappend(clob_loc, 84, ' Builder Browser group, select the name of the group from the drop-down menu and '); dbms_lob.writeappend(clob_loc, 42, ' click <b>Grant Group</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 63, '<p><b><font face="Arial" size="2">Change Access</font></b></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 88, ' <li><font face="Arial" size="2">To revoke an access right, click on the <u>revoke</u> '); dbms_lob.writeappend(clob_loc, 58, ' action link in the appropriate table row.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); --text document 'us/rsrcmgnt_rolacc.html' insert into wmp_text_docs (doc_name, doc_value,language) values ('rsrcmgnt_rolacc.html', empty_clob() ,'us'); select doc_value into clob_loc from wmp_text_docs where doc_name = 'rsrcmgnt_rolacc.html'; dbms_lob.open(clob_loc, dbms_lob.lob_readwrite); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 7, '<head> '); dbms_lob.writeappend(clob_loc, 49, '<title>Granting and Revoking Role Access</title> '); dbms_lob.writeappend(clob_loc, 8, '</head> '); dbms_lob.writeappend(clob_loc, 1, ' '); dbms_lob.writeappend(clob_loc, 82, '<p><font face="Arial Black" size="3">Granting and Revoking Role Access</font></p> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.writeappend(clob_loc, 154, '<font face="Arial" size="2">Use this page to enable access to Roles by granting or revoking access from Warehouse Builder Browser users and groups. '); dbms_lob.writeappend(clob_loc, 81, 'A list of the current users and groups that have been granted access is provided '); dbms_lob.writeappend(clob_loc, 35, 'under <b>Change Access</b>.</font> '); dbms_lob.writeappend(clob_loc, 70, '<p><font face="Arial" size="2"><b>Grant Access To User</b></font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 74, ' <li><font face="Arial" size="2">To grant an access right to a Warehouse '); dbms_lob.writeappend(clob_loc, 80, ' Builder Browser user, select the name of a user from the drop-down menu and '); dbms_lob.writeappend(clob_loc, 41, ' click <b>Grant User</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 71, '<p><font face="Arial" size="2"><b>Grant Access To Group</b></font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 74, ' <li><font face="Arial" size="2">To grant an access right to a Warehouse '); dbms_lob.writeappend(clob_loc, 122, ' Builder Browser group, select the name of the group from the drop-down menu and click <b>Grant Group</b>.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 63, '<p><font face="Arial" size="2"><b>Change Access</b></font></p> '); dbms_lob.writeappend(clob_loc, 5, '<ul> '); dbms_lob.writeappend(clob_loc, 81, ' <li><font face="Arial" size="2">To revoke an access right, click <u>revoke</u> '); dbms_lob.writeappend(clob_loc, 46, ' in the appropriate table row.</font></li> '); dbms_lob.writeappend(clob_loc, 6, '</ul> '); dbms_lob.writeappend(clob_loc, 5, '<hr> '); dbms_lob.close(clob_loc); end; end;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de