Skip to Main Content

Search

Page IdAscendingPage NameItem Data TypeRegion NameItem SequenceItem NameItem Source
1002Apex - Reports - CheckboxesPage Item (Varchar)IR10P1002_SELECTED_N-
1002Apex - Reports - CheckboxesPage Region - Interactive ReportIR20-### REGION_SOURCE=<br>select apex_item.checkbox2 ( 1, emp.empno, case when emp.job = 'MANAGER' then 'CHECKED' else '' end || ( case when deptno = 10 then ' DISABLED' else '' end) ) as empno_checkbox , apex_item.checkbox2 ( 2, emp.empno, case when emp.job = 'MANAGER' then 'CHECKED' else '' end || ' DISABLED' ) as empno_checkbox_disabled , emp.* from emp
1002Apex - Reports - CheckboxesPage Region - HTML/TextInfo100-### REGION_SOURCE=<br>A method to create a "change all" checkbox in the column heading of (interactive) reports.<br/> <br/> This is an alternative to a commonly used technique, which uses javascript function $f_CheckFirstColumn.<br/> Using that function has a few drawbacks: <ul> <li>It will always select the first checkbox column of the report, even when that is not the one you want. E.g. in this report it would select the "Was Selected" column instead of the "Select" column, because the sequence of the checkbox columns has been changed.</li> <li>$f_CheckFirstColumn does not take into account whether a checkbox is disabled; if it is disabled, you probably don't want to change its status.</li> <li>Consequently, the "select all" option is shown even when none of the checkboxes can be changed; not very elegant.</li> </ul> All these drawbacks are addressed by the method shown here.<br/> <br/> Notes: <ul> <li><b>In Apex 5 and above, you need to explicitly set the Static ID of column EMPNO_CHECKBOX to EMPNO_CHECKBOX for the javascript to work</b> (otherwise an internal id is used). This is not needed in Apex 4.2 and below.</li> <li><b>For dynamic action "P1002_SELECTED_N update (on change)", "Fire On Page Load" has to be set to true.</b> This doesn't seem logical but is needed to get this to work on 1st page load.</li> <li>Toggle the "Deptno = 10" filter to see that the "select all" checkbox is only added if there is at least 1 enabled checkbox; adding it when none of the checkboxes can be changed would not make a lot of sense.</li> </ul> <h3>Dynamic Actions</h3> <ul> <li>"EMPNO_CHECKBOX label": Adds the "select all" checkbox to the Checkbox column heading. We do this using javascript, otherwise (if you just add this to the column header definition) the checkbox html code also appears in the Actions -> Select Columns list of the report. Not very nice.</li> <li>"EMPNO_CHECKBOX_ALL javascript": Toggles the checkboxes in the report whenever the "select all" checkbox change.</li> <li>"P1002_SELECTED_N update (on change)": Updates the "Selected" number field, whenever the IR is changed. Not needed for Classic Reports, see below.</li> <li>"P1002_SELECTED_N update (after refresh)": Updates the "Selected" number field, whenever the IR is refreshed. We need both this and the "on change" dynamic action (for Interactive Reports anyway), to get both the checkbox selection and the report filter to work.</li> </ul>
1002Apex - Reports - CheckboxesPage Interactive Report---### SQL_QUERY=<br>select apex_item.checkbox2 ( 1, emp.empno, case when emp.job = 'MANAGER' then 'CHECKED' else '' end || ( case when deptno = 10 then ' DISABLED' else '' end) ) as empno_checkbox , apex_item.checkbox2 ( 2, emp.empno, case when emp.job = 'MANAGER' then 'CHECKED' else '' end || ' DISABLED' ) as empno_checkbox_disabled , emp.* from emp<br>### DETAIL_LINK_TYPE=<br>No Link Column
1003Apex - Images & Fonts - Standard Icons & FontsPage Region - HTML/TextInfo100-### REGION_SOURCE=<br>My lookup page for all Standard, Font Awesome and Font APEX icons.<br/> You do need to grant select on &F_APEX_000000_SCHEMA..wwv_flow_standard_icons to your schema for this to work.<br/> <br/> More info on Font Awesome and using it alongside Font APEX can by found on this page: <a href="f?p=&APP_ID.:1010:&SESSION.::&DEBUG.::::">Font Awesome</a>. That page also explains the use of CSS class fawe instead of fa.<br/> <br/> The official Apex Theme 42 icons page only shows Font APEX, it can be found here: <a href="https://apex.oracle.com/pls/apex/f?p=42:icons">https://apex.oracle.com/pls/apex/f?p=42:icons</a>.
1003Apex - Images & Fonts - Standard Icons & FontsPage Region - Interactive ReportStandard Icons & Fonts10-### REGION_SOURCE=<br>select t.* from ted_p1003_v t
1003Apex - Images & Fonts - Standard Icons & FontsPage Item (Varchar)Standard Icons & Fonts10P1003_MAX_IMAGE_SIZE<br>### ITEM_SOURCE=<br>32<br>### LOV_DEFINITION=<br>STATIC2:16;16,32;32,64;64,128;128,max;9999
1003Apex - Images & Fonts - Standard Icons & FontsPage Item (Varchar)Standard Icons & Fonts20P1003_FONT_SIZE<br>### ITEM_SOURCE=<br>2<br>### LOV_DEFINITION=<br>STATIC2:1x;1,2x;2,3x;3,4x;4,5x;5
1003Apex - Images & Fonts - Standard Icons & FontsPage Interactive Report---### SQL_QUERY=<br>select t.* from ted_p1003_v t<br>### DETAIL_LINK_TYPE=<br>No Link Column
1004Apex - Reports - Nowrap ColumnsPage Region - HTML/TextIR - Number / Date Format40-### REGION_SOURCE=<br>Report Attributes -&gt; Column Definition -&gt; Number / Date Format:<br/> Use &amp;nbsp; instead of spaces, e.g.:<br/> <br/> <textarea class="textarea codemirror-css">DD-MM-YYYY"&amp;nbsp;"HH24:MI:SS</textarea> <br/> Column Definition -> Display Type: Set to Standard Report Column. <br>### RCONDITION_TYPE=<br>Never
1004Apex - Reports - Nowrap ColumnsPage Region - HTML/TextInteractive Reports - General20-### REGION_SOURCE=<br>Column Formatting -&gt; HTML Expression: use a &lt;span&gt; construct like this:<br/> <br/> <textarea class="textarea codemirror-css">&lt;span style=&quot;white-space:nowrap;&quot;&gt;#COLUMN_NAME#&lt;/span&gt;</textarea>
1004Apex - Reports - Nowrap ColumnsPage Region - HTML/TextInteractive Reports - Link30-### REGION_SOURCE=<br>Column Link -&gt; Link Text: use a &lt;span&gt; construct like this:<br/> <br/> <textarea class="textarea codemirror-css">&lt;span style=&quot;white-space:nowrap;&quot;&gt;#COLUMN_NAME#&lt;/span&gt;</textarea>
1004Apex - Reports - Nowrap ColumnsPage Region - HTML/TextStandard Reports10-### REGION_SOURCE=<br>Report Attributes -> Column Attributes -> Column Formatting -> CSS Style:<br/> <pre> white-space:nowrap; </pre>
1005Apex - Images & Fonts - WebDavPage Region - HTML/TextAccessing the /i/ images folder using WebDav10-### REGION_SOURCE=<br>Creating a Web Folder in Windows XP:<br/> 1. In Windows Explorer right click My Network Places and select Open<br/> 2. From the Network Tasks side menu select Add Network Place<br/> 3. In the Add Network Place Wizard click Next<br/> 4. Select Choose another network location and click Next<br/> 5. Enter the location of your APEX images path e.g. &#x201c;http://127.0.0.1:8080&#x201d;<br/> 6. You will be prompted to enter your XDB username (usually system) and password<br/> 7. In the wizard, enter a name for the network place e.g. &#x201c;APEX Images&#x201d;<br/> 8. Click Finish<br/> <br/> Note: on Windows 7, locate the Add Network Location Wizard like this: &quot;Either click on Computer from the Start Menu or click on Computer in Windows Explorer. Right-click anywhere in the blank area of the right-side pane, and choose &quot;Add a Network Location&quot; <br/> When Windows (especially 7 it seems) keeps coming up with this error message &quot;The folder you entered does not appear to be valid.&quot;, then try a WebDAV client like <a href="http://www.bitkinex.com/webdavclient">http://www.bitkinex.com/webdavclient</a>.
1006Apex - Reports - ErrorsPage Region - HTML/TextInvalid set of rows requested, the source data of the report has been modified20-### REGION_SOURCE=<br>&quot;You need to reset pagination for the pages where you have your reports on. There's a process type &quot;reset pagination&quot; that lets you specify which pages you want to reset pagination on. You need to figure out when to best call this process, e.g. on load of your page 1, since you're not submitting page 1 but rather just link to another page.&quot;<br/> <br/> Source: <a href="http://forums.oracle.com/forums/thread.jspa?messageID=1819376&amp;#1819376">http://forums.oracle.com/forums/thread.jspa?messageID=1819376&amp;#1819376</a><br/> Note: &quot;On Load &#x2013; After Footer&quot; works well.<br/> <br/> <br/> An interesting article by Patrick Wolf on this subject, or more specifically the question &quot;<i>Is there a possibility to reset only the pagination of the detail report, when you have a master- and a detail report on the same page in an Oracle Application Express (APEX) application?&quot;</i>: <a href="http://www.inside-oracle-apex.com/resetting-pagination-of-master-detail-report-in-oracle-apex/">http://www.inside-oracle-apex.com/resetting-pagination-of-master-detail-report-in-oracle-apex/</a>
1006Apex - Reports - ErrorsPage Region - HTML/TextORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_COLUMNS_UK2) violated40-### REGION_SOURCE=<br>When creating a new report page/region (or changing the SQL of an existing report), you can get this error:<br/> <br/> Error creating page region.<br/> ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_COLUMNS_UK2) violated<br/> <br/> Cause: <i>&quot;The error came from using 2 columns of different tables without synonym&quot;</i> - e.g.: <textarea class="textarea codemirror-sql">select r.id , r.name , a.name from table_r r join table_a a on a.id = r.a_id</textarea> <br/> Source: <a href="https://community.oracle.com/thread/881214?tstart=0">https://community.oracle.com/thread/881214?tstart=0</a><br/>
1006Apex - Reports - ErrorsPage Region - HTML/TextORA-01461: can bind a LONG value only for insert into a LONG column30-### REGION_SOURCE=<br>&quot;Creating a STANDARD report (non interactive) - using the CREATE PAGE wizard or the CREATE REGION wizard, after entering in the SQL, it will throw a simple error page (wwv_flow.accept) showing the error ORA-01461: can bind a LONG value only for insert into a LONG column<br/> Workaround:<br/> Run the same wizard with select * from dual to get the page and region created.<br/> Once it is created - edit the region - and place the long nasty query in the region source. It will then take and work as expected.&quot;<br/> <br/> Source: <a href="https://community.oracle.com/thread/2176773?tstart=0">https://community.oracle.com/thread/2176773?tstart=0</a><br/>
1006Apex - Reports - ErrorsPage Region - HTML/TextORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small10-### REGION_SOURCE=<br>&quot;Your tabular form probably has one or more columns displayed as select lists. The error occurs when the number of rows in one of the lists is too great and/or when the generated HTML for the displayed report row exceeds 32K. You will need to change the problem column to use a popup LOV display type or reduce the number of rows in the select list LOV or reduce the size of the displayed data for each row in the LOV.&quot;<br/> <br/> Source: <a href="http://forums.oracle.com/forums/thread.jspa?messageID=3722079&amp;#3722079">http://forums.oracle.com/forums/thread.jspa?messageID=3722079&amp;#3722079</a><br/> <br/> <br/> &quot;I think would depend on whether or not the LOVs are dynamic - that is, they are based on values in other fields on the record. If they are simple lists that would be the same in every record, then you could construct the lists using PL/SQL in a hidden region at the bottom of the page and then use javascript to populate all of of the select lists on the page.&quot;<br/> <br/> Source: <a href="http://forums.oracle.com/forums/thread.jspa?messageID=3901749&amp;#3901749">http://forums.oracle.com/forums/thread.jspa?messageID=3901749&amp;#3901749</a><br/>
1007Apex - Reports - DownloadPage Region - ReportClassic Report - Download Button40--
1007Apex - Reports - DownloadPage Region - HTML/TextHide columns in CSV/PDF (etc) Export30-### REGION_SOURCE=<br>You can hide columns by putting a condition on them of type PL/SQL Expression and using the following as the expression:<br/> <textarea class="textarea codemirror-sql">NVL(:REQUEST,'EMPTY') not in ('CSV','XLS','PDF','HTMLD','RTF')</textarea> That will check the APEX bind variable &quot;REQUEST&quot;, and if it is CSV, XLS, PDF, HTMLD or RTF then the column will not be shown.<br/> Note that newer Apex versions also have an &quot;Include In Export / Print&quot; option, which might be sufficient for most purposes.<br/> <br/> To stop a column from showing up for an email, you can use the following:<br/> <textarea class="textarea codemirror-sql">NVL(wwv_flow.g_widget_action, 'EMPTY') != 'SEND_EMAIL'</textarea> <br/> Source: <a href="http://stackoverflow.com/questions/9700660/apex-interactive-report-hide-column-in-csv-download">http://stackoverflow.com/questions/9700660/apex-interactive-report-hide-column-in-csv-download</a><br/> Note: This source suggests using XML as one of the :REQUEST options. That is incorrect, this should be HTMLD as in the example above.
1007Apex - Reports - DownloadPage Region - HTML/TextUTF-8 issues20-### REGION_SOURCE=<br>Symptoms: Report looks OK in the browser, but export to CSV gives problems with exotic characters.<br/> <br/> Fix:<br/> <pre>Set [Shared Components -&gt; Application -&gt; Definition -&gt; Globalization -&gt;] Automatic CSV Encoding to No.</pre> Now when I run page 8 in your application and I download to CSV, it is properly encoded in UTF-8. Of course, when my version of Excel opens it up directly, the characters appear corrupted again because my version of Excel expects windows-1252 encoding. However, if I import the data in Excel (Data -&gt; From Text), and I choose File Origin of 65001: Unicode (UTF-8), all of the data appears correct.&quot;<br/> <br/> <br/> Source: <a href="http://forums.oracle.com/forums/thread.jspa?messageID=9308830&amp;#9308830">http://forums.oracle.com/forums/thread.jspa?messageID=9308830&amp;#9308830</a>
1008Apex - General - ConditionsPage Region - HTML/TextCondition Type 'Client Browser: Microsoft Internet Explorer' not working for IE 1110-### REGION_SOURCE=<br>For IE 11 this condition type does not work, because of changes in the HTTP User Agent that IE 11 uses.<br/> More info: <a href="http://www.nczonline.net/blog/2013/07/02/internet-explorer-11-dont-call-me-ie/">http://www.nczonline.net/blog/2013/07/02/internet-explorer-11-dont-call-me-ie/</a><br/> <br/> Solution: Use this Condition Type &quot;PL/SQL Expression&quot;: <pre>owa_util.get_cgi_env('HTTP_USER_AGENT') like '%Trident%'</pre> <br/> Note that this doesn't apply to Edge, for that browser you would need something like: <pre>owa_util.get_cgi_env('HTTP_USER_AGENT') like '%Edge%'</pre>
1009Apex - Reports - Substitution StringsPage Item (Varchar)IR10P1009_REPORT_TOTAL_ROWS-
1009Apex - Reports - Substitution StringsPage Region - Interactive ReportIR20-### REGION_SOURCE=<br>select emp.* from emp
1009Apex - Reports - Substitution StringsPage Item (Varchar)IR20P1009_REPORT_ROWS_SHOWN-
1009Apex - Reports - Substitution StringsPage Region - HTML/TextInfo100-### REGION_SOURCE=<br>Method to use the substitution strings from the Region Footer of (interactive) reports for other purposes.<br/> <br/> In the example above, the #TOTAL_ROWS#; substitution string is used to fill page item P1009_REPORT_TOTAL_ROWS, using jquery.<br/> The value of this page item can then be used in dynamic actions, e.g. to show/hide other items.<br/> <b>Note:</b> Make sure that in your page template, the javascript substitution strings listed below are located in the Header and not in the Footer.<br/> E.g. in Theme 42 of Apex 5.0 these are located in the footer, resulting in Javascript error "ReferenceError: $s is not defined".<br/> <pre>#APEX_JAVASCRIPT# #THEME_JAVASCRIPT# #TEMPLATE_JAVASCRIPT# #APPLICATION_JAVASCRIPT# #PAGE_JAVASCRIPT# </pre> Item P1009_REPORT_ROWS_SHOWN contains the number of rows that are actually displayed in an Interactive Report; it is not useful for Classic Reports.<br/> The number of rows displayed changes whenever e.g. using filters or changing the number of rows of the IR. Those types of IR actions have no effect on the substitution strings, since they refresh the report itself using PPR (Partial Page Refresh) and not the footer that contains the substitution strings. <br/> <h2>Dynamic Actions</h2> P1009_REPORT_ROWS_SHOWN (2x):<br/> Note that we need 2 versions, because the class we are searching for got a new name in Apex 5.<br/> Note also that you will probably need to substitute &quot;LINK&quot; for another column header, one that exist in your report and that cannot be hidden by the user.<br/> <br/> To use P1009_REPORT_TOTAL_ROW, create true/false actions to show/hide items (or to perform any other actions you want).
1009Apex - Reports - Substitution StringsPage Region - HTML/TextWarning 18.110-### REGION_SOURCE=<br><div style="background-color: yellow; padding: 10px; text-align: center;"> Warning: As of Apex 18.1, the solution below does not work anymore. </div>
1009Apex - Reports - Substitution StringsPage Interactive Report---### SQL_QUERY=<br>select emp.* from emp<br>### DETAIL_LINK_TYPE=<br>No Link Column
1010Apex - Images & Fonts - Font AwesomePage Region - HTML/TextCombining fonts100-### REGION_SOURCE=<br>Sometimes you want to combine Font Awesome with other fonts, e.g. when you need alphanumeric characters.<br/> <br/> In Example 1 below, the "quick-and-dirty" approach causes the A (and its label) to be placed too high, compared to the B. Also, this will look slightly different in various browsers - and probably none of them will look OK.<br/> <br/> In example 2, I solved this by using an "invisible" Font Awesome character, so that everything (i.e. the label) is placed in the correct spot. Then the A is placed on top of that.<br/> Not the most elegant solution maybe, but this was the only trick I could think of that gets the label in the correct place in all browsers. The position of the A relative to the label is a bit browser-dependent, but close enough so as not to bother me too much :-)<br/> <br/>
1010Apex - Images & Fonts - Font AwesomePage Region - HTML/TextFont Awesome10-### REGION_SOURCE=<br><a href="http://fortawesome.github.io/Font-Awesome/">http://fortawesome.github.io/Font-Awesome/</a><br/> <br/> In the latest Apex versions, you have to choose between either Font Awesome or Font APEX to use in a theme, but you can use both if you want.<br/> Maxime Tremblay has a nice blog post on that topic: <a href="http://max-tremblay.blogspot.com/2018/01/use-font-apex-and-font-awesome.html">http://max-tremblay.blogspot.com/2018/01/use-font-apex-and-font-awesome.html</a>. I have used his method for my site as well, so I'm also using the fawe prefix in these examples.<br/> <br/> <i> <b>APEX 5.0: Upgrade to the newest FontAwesome Icon Library</b><br/> Oracle APEX 5.0 ships with FontAwesome version 4.2.0 which will automatically be loaded if your application is using the Universal Theme. This makes it super easy to add nice looking icons to your buttons, lists and regions. But how can you integrate the most current version of FontAwesome if you have found an icon on the FontAwesome Icon Gallery which is not already part of 4.2.0? Actually that’s pretty straight forward! </i> <br/> Info on how to do this: <a href="http://www.inside-oracle-apex.com/apex-5-0-upgrade-to-the-newest-fontawesome-icon-library/">http://www.inside-oracle-apex.com/apex-5-0-upgrade-to-the-newest-fontawesome-icon-library/</a><br/> <br/> Note: Font Awesome version 4 is quite different from version 5, so work may be required to upgrade to that version - see <a href="https://fontawesome.com/how-to-use/on-the-web/setup/upgrading-from-version-4">https://fontawesome.com/how-to-use/on-the-web/setup/upgrading-from-version-4</a> for details.<br/> <br/> Note: In Apex 5.1 and up, the fa-2x/fa-3x/etc classes don't seem to work anymore. The font sizes are overruled by a &quot;font-size: 14px;&quot; entry in core.min.css. Seems like a bug to me; I guess caused by the introduction of Font APEX icon library, since the fa-2x/3x/etc classes do work for those icons. I've fixed it here by adding some css in the element itself, but of course that's not very elegant...</a><br/> <br/>
1010Apex - Images & Fonts - Font AwesomePage Region - HTML/TextFont example 1110-### REGION_SOURCE=<br><table> <tr> <td style="width: 100px;"> <section style="text-align: center; height: 90px; margin-right: 6px; padding: 5px; background-color:#004A60; overflow: hidden;"> <div style="position: relative; top: 50%; -webkit-transform: translateY(-50%); -ms-transform: translateY(-50%); transform: translateY(-50%); color: #FFFFFF; font-size:10pt;"> <div> <span style="font-family:helvetica,arial,sans-serif; font-weight:bold; font-size: 3.8em;">A</span> </div> Label A </div> </section> </td> <td style="width: 100px;"> <section style="text-align: center; height: 90px; padding: 5px; background-color:#004A60; overflow: hidden;"> <div style="position: relative; top: 50%; -webkit-transform: translateY(-50%); -ms-transform: translateY(-50%); transform: translateY(-50%); color: #FFFFFF; font-size:10pt;"> <i class="fawe fawe-fire-extinguisher" style="margin-bottom: 3px; font-size: 3em;"></i><br/> Label B </div> </section> </td> </tr> </table>
1010Apex - Images & Fonts - Font AwesomePage Region - HTML/TextFont example 2120-### REGION_SOURCE=<br><table> <tr> <td style="width: 100px;"> <section style="text-align: center; height: 90px; margin-right: 6px; padding: 5px; background-color:#004A60; overflow: hidden;"> <div style="position: relative; top: 50%; -webkit-transform: translateY(-50%); -ms-transform: translateY(-50%); transform: translateY(-50%); color: #FFFFFF; font-size:10pt;"> <div> <i class="fawe fawe-spinner" style="color: #004A60; margin-bottom: 3px; font-size: 3em;"></i> <span style="font-family:helvetica,arial,sans-serif; font-weight:bold; font-size: 3.8em; position: absolute; -webkit-transform: translate(-37px, 9px); -ms-transform: translate(-37px, 9px); transform: translate(-37px, 9px);">A</span> </div> Label A </div> </section> </td> <td style="width: 100px;"> <section style="text-align: center; height: 90px; padding: 5px; background-color:#004A60; overflow: hidden;"> <div style="position: relative; top: 50%; -webkit-transform: translateY(-50%); -ms-transform: translateY(-50%); transform: translateY(-50%); color: #FFFFFF; font-size:10pt;"> <i class="fawe fawe-fire-extinguisher" style="margin-bottom: 3px; font-size: 3em;"></i><br/> Label B </div> </section> </td> </tr> </table>
1010Apex - Images & Fonts - Font AwesomePage Region - HTML/TextFun with Spinners200-### REGION_SOURCE=<br>Simple animations with fa(we)-spin and some padding:<br/> <br/> <table> <tr> <td style="width: 200px;"> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">1:</span> <i class="fawe fawe-spinner fawe-spin" style="font-size: 2em;"></i> </div> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">2:</span> <i class="fawe fawe-spinner fawe-spin" style="padding-bottom: 20px; font-size: 2em;"></i> </div> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">3:</span> <i class="fawe fawe-spinner fawe-spin" style="color: white; padding-bottom: 20px;"> <i class="fawe fawe-spinner fawe-spin" style="color: black; padding-bottom: 20px; font-size: 2em;"></i> </i> </div> </td> <td style="width: 200px;"> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">1:</span> <i class="fawe fawe-spinner fawe-spin" style="border: 1px solid red; font-size: 2em;"></i> </div> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">2:</span> <i class="fawe fawe-spinner fawe-spin" style="border: 1px solid red; padding-bottom: 20px; font-size: 2em;"></i> </div> <div style="margin-bottom: 20px;"> <span style="margin-right: 20px;">3:</span> <i class="fawe fawe-spinner fawe-spin" style="color: white; border: 1px solid red; padding-bottom: 20px;"> <i class="fawe fawe-spinner fawe-spin" style="color: black; border: 1px solid blue; padding-bottom: 20px; font-size: 2em;"></i> </i> </div> </td> </tr> </table>
1011Apex - General - AutocompletePage Region - HTML/TextExample 110--
1011Apex - General - AutocompletePage Item (Varchar)Example 110P1011_FAKEUSERNAME-
1011Apex - General - AutocompletePage Item (Varchar)Example 120P1011_FAKEPASSWORD-
1011Apex - General - AutocompletePage Item (Varchar)Example 130P1011_USERNAME-
1011Apex - General - AutocompletePage Item (Varchar)Example 140P1011_PASSWORD-
1011Apex - General - AutocompletePage Region - HTML/TextExample 220--
1011Apex - General - AutocompletePage Item (Varchar)Example 2130P1011_USERNAME_2-
1011Apex - General - AutocompletePage Item (Varchar)Example 2140P1011_PASSWORD_2-
1011Apex - General - AutocompletePage Region - HTML/TextInfo100-### REGION_SOURCE=<br><h3>Disable browser autocomplete feature on form fields.</h3> Modern browsers are getting quite persistant when it comes to automatically filling in form fields with username/password combination they feel to be the right ones. Most of the time that works fine, but if it doesn't then it's a pain.<br/> The html option autocomplete=off was/is meant exactly for this purpose, but is completely ignored nowadays.<br/> <br/> These 2 solutions do work in most situations. The first one worked fine in the past, but browsers are getting a bit too smart for that one. The second one works like a charm as far as I can tell, and is quite elegant as well: <ul> <li>Example 1: Adding 2 hidden username/password fields, to trick the browser into using those 2 instead of the real ones.<br/> More info: <a href="http://stackoverflow.com/questions/15738259/disabling-chrome-autofill">http://stackoverflow.com/questions/15738259/disabling-chrome-autofill</a> </li> <li>Example 2: Adding a temporary readonly tag to the input fields, to trick the browser into ignoring them until it is too late.<br/> More info: <a href="https://stackoverflow.com/questions/32369/disable-browser-save-password-functionality/37292424#37292424">https://stackoverflow.com/questions/32369/disable-browser-save-password-functionality/37292424#37292424</a><br/> Note that I use onfocusin instead of onfocus. IE 11 (and earlier versions as well, probably) has a bug that prevents you from entering text into the field until you click it again. That bug is described (but not solved) <a href="https://stackoverflow.com/questions/31947590/unable-to-focus-an-input-using-javascript-in-ie11">here</a>. Other modern browsers, including IE's successor Edge, work fine with onfocus. </li> </ul>
1012Apex - General - ErrorsPage Region - HTML/TextHTTP 400 - Bad request Page cannot be found20-### REGION_SOURCE=<br>Or (in other browsers): HTTP 400 - Bad Request - The HTTP client sent a request that this server could not understand.<br/> When submitting a form with a lot of arguments (parameters), you may get this error. More info and solutions in the links below.<br/> <br/> <br/> <a href="https://community.oracle.com/thread/2409100">https://community.oracle.com/thread/2409100</a><br/> <i>&quot;Sounds like you're submitting too many parameters (15 * 130 = 1950), very close to 2000<br/> Check this post regarding PlsqlMaxParameters:<br/> <a href="https://community.oracle.com/thread/272149">https://community.oracle.com/thread/272149</a><br/> One of our developers has used a wizard to create a tabular form with the intent or providing an interface for updating one of our tables. The page runs correctly up until the point when the user clicks the Submit button. The user is then re-directed to a "page cannot be found" error page. I checked the apache error log and I'm seeing this error (ip addresses hidden): <br/> [Wed Oct 13 06:37:59 2004] [error] [client x.xxx.xxx.xxx] [ecid: 1097674679:x.xx.xxx.xx:7286:0:23738,0] mod_plsql: /pls/htmldb/wwv_flow.accept HTTP-400 Too many arguments passed in. Got 2009 parameters. Upper limit is 2000&quot;</i><br/> <br/> <br/> <a href="http://jk-consult.nl/tag/plsqlmaxparameters/">http://jk-consult.nl/tag/plsqlmaxparameters/</a><br/> <i>&quot;To resolve the issue the PlsqlMaxParameter needed to be added to plsql.conf. (We tried to do this in dads.conf to keep most of Oracle HTTP Server unaffected, but got errored out).<br/> We chose the value of 4000, meaning a 100% increase while maintaining a fair and safe limit.<br/> <br/> For Oracle HTTP Server, the parameter is set in plsql.conf which can be found in either:<br/> $ORACLE_BASE/Oracle_WT1/instances/instance1/config/OHS/ohs1/moduleconf<br/> $ORACLE_BASE/ohs/Apache/modplsql/conf<br/> <br/> For Oracle EPG, the parameter can be set as follows:<br/> dbms_epg.set_global_attribute(‘max-parameters’, ‘100’);&quot;</i><br/> <br/> <br/> A workaround using collections by Denes Kubice is described here: <a href="https://apex.oracle.com/pls/apex/f?p=31517:294">https://apex.oracle.com/pls/apex/f?p=31517:294</a><br/>
1012Apex - General - ErrorsPage Region - HTML/TextORA-01461: can bind a LONG value only for insert into a LONG column30-### REGION_SOURCE=<br>In Apex (4.2.2) you'll get this error if the pl/sql code of a page validation you edit is longer than 4000 characters.<br/> This will probably happen in other places as well.
1012Apex - General - ErrorsPage Region - HTML/TextORA-20102: Application collection PLSQL_OBJECT_SOURCE does not exist40-### REGION_SOURCE=<br>When using the Object Browser in Apex ("SQL Workshop -> Object Browser") to edit and compile objects, you may run into this error.<br/> This seems to be caused solely by the size of the object that you try to compile. In my case a view of 3400 bytes had this issue, while a view of 1200 bytes compiled just fine.<br/> <br/> A Google search does not give many hits or suggestions. I found the hint about the object size at <a href ="https://community.oracle.com/thread/1043317?start=15&tstart=0">https://community.oracle.com/thread/1043317?start=15&tstart=0</a>. Note that this post is from 2011, and that the bug still exists in Apex 19.2...<br/> <br/> The solution is simple but not very elegant: copy/paste the source into the "SQL Workshop -> SQL Commands" window and run it there.
1012Apex - General - ErrorsPage Region - HTML/TextTimeout errors - After Submit & Automatic Row Processing (DML)10-### REGION_SOURCE=<br>When submitting a page using After Submit with Automatic Row Processing (DML) <i>and</i> a PL/SQL Anonymous Block process (that also does DML), you sometimes get timeout errors.<br/> Or, when using i.e. Tomcat, errors like "No more data to read from socket".<br/> <br/> In the trace logs you find stuff like this:<br/> <pre>*** 2014-06-20 17:07:00.257 Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x8] [PC:0x25DFBB3, pesl_src_dst_cmp()+691] [flags: 0x0, count: 1] *** 2014-06-20 17:07:00.786 Incident 5043 created, dump file: /u01/app/oracle/diag/rdbms/staging/staging/incident/incdir_5043/staging_ora_16614_i5043.trc ORA-07445: exception encountered: core dump [pesl_src_dst_cmp()+691] [SIGSEGV] [ADDR:0x8] [PC:0x25DFBB3] [Address not mapped to object] [] ssexhd: crashing the process... Shadow_Core_Dump = PARTIAL</pre> <br/> Cause: both the Automatic Row Processing (DML) and the PL/SQL Anonymous Block try to manipulate the same row.<br/> <br/> Solution: Use either Automatic Row Processing (DML) or the PL/SQL Anonymous Block, not both.<br/>
1013Apex - General - Items used in pl/sqlPage Region - HTML/TextItems used in pl/sql10-### REGION_SOURCE=<br>Use the package below to find where Apex items are used in pl/sql code.<br/> Useful for finding items that have been renamed/removed from the Apex application, but are still reference in pl/sql code - in which case the value would be null, possibly resulting in all sorts of strange behaviour.<br/> <br/> <br/> Usage example, to find all Apex items that are referenced in pl/sql packages named like PCK% (specification or body), but that do not exist in Apex application ID 25384:<br/> <textarea class="textarea codemirror-sql">select i.* from table(ted_apex_items.user_source_items) i where i.name like 'PCK%' and i.type like 'PACKAGE%' and i.item_name not in ( select api.item_name from apex_application_items api where api.application_id = 25384 ) and i.item_name not in ( select app.item_name from apex_application_page_items app where app.application_id = 25384 )</textarea>
1014(PL)SQL - External TablesPage Region - HTML/TextExternal Tables - Example10-### REGION_SOURCE=<br>Working example, execute as sys:<br/> <textarea class="textarea codemirror-sql">create or replace directory import_dir as '/home/oracle/consulta_import'; grant read on directory import_dir to some_user; grant write on directory import_dir to some_user;</textarea> Execute as some_user: <textarea class="textarea codemirror-sql">CREATE TABLE ADDR_MNLA_CONSULTA_EXT ( municipio varchar2(100) , cod_ibge varchar2(10) , uf varchar2(2) , nome_rua varchar2(100) , cep varchar2(10) ) ORGANIZATION EXTERNAL ( TYPE oracle_loader DEFAULT DIRECTORY import_dir ACCESS PARAMETERS ( RECORDS DELIMITED BY NEWLINE SKIP 1 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' MISSING FIELD VALUES ARE NULL (municipio, cod_ibge, uf, nome_rua, cep) ) LOCATION ('consulta_utf8.csv') ) ; </textarea>
1015DBA - TablespacesPage Region - HTML/TextSet maximum autoextend of a datafile20-### REGION_SOURCE=<br>Find the file_name of a specific datafile.<br/> Execute as sys or system: <textarea class="textarea codemirror-sql">select df.file_name , df.bytes , df.maxbytes from dba_data_files df where df.status = 'AVAILABLE' and df.tablespace_name = 'INT_DATA'</textarea> <br/> Set the maximum autoextend size of a specific datafile.<br/> Execute as sys or system: <textarea class="textarea codemirror-sql">ALTER DATABASE DATAFILE '/u02/oradata/ISRP/datafile/o1_mf_int_data_5r7ohy0p_.dbf' AUTOEXTEND ON MAXSIZE 32767M;</textarea>
1015DBA - TablespacesPage Region - HTML/TextTablespace Usage10-### REGION_SOURCE=<br>Query to determine tablespace usage (for both data and temp), taking into account any autoextend settings.<br/> Autoextend is ignored by sys.sm$ts_used, so that view is not really usable. The results from that view are shown in column pct_used_wrong, the correct result is shown in column pct_used.<br/> <br/> Execute as sys or system:<br/> <textarea class="textarea codemirror-sql">select t.tablespace_name , t.status , trunc( nvl(tsu.bytes,0) / 1024) as used_k , trunc( dbf.bytes/1024 ) as size_k , trunc( dbf.maxbytes/1024 ) as maxsize_k , round( nvl(tsu.bytes,0) / dbf.bytes * 100 ) as pct_used_wrong , round( nvl(tsu.bytes,0) / dbf.maxbytes * 100 ) as pct_used from sys.dba_tablespaces t , sys.sm$ts_used tsu , ( select f.tablespace_name , sum(bytes) as bytes , sum( decode( f.autoextensible ,'YES',(case when f.maxbytes&lt;f.bytes then f.bytes else f.maxbytes end) /*case is needed to prevent silly numbers due to configuration errors*/ ,f.bytes ) ) as maxbytes from ( select tablespace_name, bytes, maxbytes, autoextensible from dba_temp_files where status = 'ONLINE' union all select tablespace_name, bytes, maxbytes, autoextensible from dba_data_files where status = 'AVAILABLE' ) f group by f.tablespace_name ) dbf where t.tablespace_name = dbf.tablespace_name (+) and t.tablespace_name = tsu.tablespace_name (+) order by pct_used desc </textarea>
  • 1 - 50