tag:blogger.com,1999:blog-43784977152236622522023-11-16T07:10:22.660+05:30Kartik PatelOracle Application Express Developer Competition 2009 WinnerKartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.comBlogger16125tag:blogger.com,1999:blog-4378497715223662252.post-16700126976872285522011-04-04T15:16:00.000+05:302011-04-04T15:16:58.022+05:30Pro in Oracle Forum<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYtX3PfwevLjP0DLy616ymNlcf8_d2uxCDiaoIU38uWTir4-HpNdLHNrjPyatKjBtecrlnjiO71aG1eLzWu7tfFN3kPNFx7mkdr4TGZDglY4iqFl845av6iQPwIFHVBfSK4HBVcPm3D3a9/s1600/500+points.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="268" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhYtX3PfwevLjP0DLy616ymNlcf8_d2uxCDiaoIU38uWTir4-HpNdLHNrjPyatKjBtecrlnjiO71aG1eLzWu7tfFN3kPNFx7mkdr4TGZDglY4iqFl845av6iQPwIFHVBfSK4HBVcPm3D3a9/s640/500+points.JPG" width="640" /></a></div><br />
Now my status level is <b>Pro</b> in Oracle Forum.</div>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-120685440015650192011-01-25T11:35:00.000+05:302011-01-25T11:35:13.312+05:30Save Before Exit plugin from SkillBuilder<div dir="ltr" style="text-align: left;" trbidi="on">It is possible that you fill data in form and some case you left the page without saving your work?<br />
<br />
So that entered data will lost.<br />
<br />
There is a plug-in Save Before Exit from SkillBuilder to prevent this issue.<br />
<br />
Download the plug-in from: <a href="http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/skillbuilders-save-before-exit_43.html">http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/skillbuilders-save-before-exit_43.html</a><br />
<br />
Installation steps:<br />
<ol style="text-align: left;"><li>Unzip the downloaded file.</li>
<li>In your APEX screen go to shared document and then Plug-ins and click on Import.</li>
<li>It will ask for selecting file. Choose dynamic_action_plugin_com_skillbuilders_sbdp_save_before_exit.sql and follow the steps.</li>
<li>This will install plug-in into your application</li>
</ol>Configuration in page:<br />
<ol style="text-align: left;"><li> Go to page where you want to add save before exit feature.</li>
<li>Create a dynamic action.</li>
<li>Select advanced and give the name of dynamic action.</li>
<li>Choose page load on Event and next.</li>
<li>select "SkillBuilders Save Before Exit (2.0.0) [Plug-in]" in action and click on next.</li>
<li>Click on create button to create dynamic action.</li>
</ol>If you want to add this feature in multiple page then you can create this dynamic action on Page 0 and give the condition that execute on list of pages.<br />
<br />
Demo: <a href="http://apex.oracle.com/pls/apex/f?p=KP:SBE">http://apex.oracle.com/pls/apex/f?p=KP:SBE</a> <br />
<br />
</div>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-60173513861121011542010-11-24T18:02:00.000+05:302010-11-24T18:02:45.749+05:30Journeyman in Oracle Forum<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5cCaOMFnbjqk5H3avG2S1pLFhyjqUB1AT_MgjH7CYy_VNTOw2zRnxRXJ6w4GwH31y3ZhVTU-_KHgz6pJiG5AxbIztLO7S5SVY8ciic6HKQerwjiZ6MMDuFgwWAUtEu76NKBdBcPHX9-Vs/s1600/200+Points.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="135" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg5cCaOMFnbjqk5H3avG2S1pLFhyjqUB1AT_MgjH7CYy_VNTOw2zRnxRXJ6w4GwH31y3ZhVTU-_KHgz6pJiG5AxbIztLO7S5SVY8ciic6HKQerwjiZ6MMDuFgwWAUtEu76NKBdBcPHX9-Vs/s320/200+Points.JPG" width="320" /></a></div>I am a Journeyman : 200 - 499 pt. <br />
<a href="http://forums.oracle.com/forums/profile.jspa?userID=777059">http://forums.oracle.com/forums/profile.jspa?userID=777059</a>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com1tag:blogger.com,1999:blog-4378497715223662252.post-62082954388619838182010-11-20T14:30:00.001+05:302010-11-20T14:31:21.110+05:30Oracle Application Express New Patch 4.0.2.00.06 Release<b>A new Oracle APEX patchset release with lots of bugfixes.</b><br />
<br />
The following table lists bugs fixed in the Oracle Application Express 4.0.2.00.06 patch set.<br />
<a href="http://www.blogger.com/post-edit.g?blogID=4378497715223662252&postID=6208295438861983818" id="sthref10" name="sthref10"></a><a href="http://www.blogger.com/post-edit.g?blogID=4378497715223662252&postID=6208295438861983818" id="sthref11" name="sthref11"></a><br />
<div class="titleintable"><br />
</div><table border="1" cellpadding="3" cellspacing="0" class="Formal" dir="ltr" frame="hsides" rules="groups" summary="This table contains a list of the bugs fixed in the Oracle Application Express 4.0.2.00.06. patch set." title="Bugs Fixed in the Oracle Application Express 4.0.2.00.06 Patch Set"><colgroup><col width="13%"></col><col></col></colgroup><thead>
<tr align="left" valign="top"><th align="left" id="r1c1-t6" valign="bottom">Bug Number</th><th align="left" id="r1c2-t6" valign="bottom">Description</th></tr>
</thead><tbody>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r2c1-t6">6360643</td><td align="left" headers="r2c1-t6 r1c2-t6">Missing <code>RESTRICT_TO_USER_LIST</code> in application export</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r3c1-t6">9752881</td><td align="left" headers="r3c1-t6 r1c2-t6">Read only quick picks on 4000:4311 and 4000:371 should show "Always"</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r4c1-t6">9855165</td><td align="left" headers="r4c1-t6 r1c2-t6">Incorrect results when viewing session state from Developer toolbar</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r5c1-t6">10024385</td><td align="left" headers="r5c1-t6 r1c2-t6">Ignore case and blanks in attributes which are referencing page items</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r6c1-t6">10024437</td><td align="left" headers="r6c1-t6 r1c2-t6">Flash 5 dial chart incorrect value displayed when value should be zero</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r7c1-t6">10024919</td><td align="left" headers="r7c1-t6 r1c2-t6">Map attribute labels does not control visibility of labels on map</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r8c1-t6">10030517</td><td align="left" headers="r8c1-t6 r1c2-t6">Popup LOV uses HTML Form Element attributes for anchor link</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r9c1-t6">10030798</td><td align="left" headers="r9c1-t6 r1c2-t6">Interactive report CSV download includes extra pair of DIV tags</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r10c1-t6">10037373</td><td align="left" headers="r10c1-t6 r1c2-t6">Unable to create forms conversion project using Internet Explorer 7 and Application Express Listener</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r11c1-t6">10041505</td><td align="left" headers="r11c1-t6 r1c2-t6">Popup LOV search should use LIKE operator</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r12c1-t6">10041816</td><td align="left" headers="r12c1-t6 r1c2-t6">Multi Row Delete process fails in some cases when display sequence was altered</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r13c1-t6">10049423</td><td align="left" headers="r13c1-t6 r1c2-t6">Named report template page not displayed when called from Page Edit tree</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r14c1-t6">10050404</td><td align="left" headers="r14c1-t6 r1c2-t6">String from other pages included in XLIFF page export</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r15c1-t6">10051384</td><td align="left" headers="r15c1-t6 r1c2-t6">Flash 5 Gantt chart does not support 'DS' application date format</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r16c1-t6">10055032</td><td align="left" headers="r16c1-t6 r1c2-t6">Children do not show up or are wrong in Query Builder</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r17c1-t6">10055407</td><td align="left" headers="r17c1-t6 r1c2-t6">Theme 1 - Hide/Show region template missing float left</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r18c1-t6">10057703</td><td align="left" headers="r18c1-t6 r1c2-t6">Cannot make 'Simple Checkbox' columns conditional</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r19c1-t6">10058590</td><td align="left" headers="r19c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.LOG_LONG_MESSAGE</code> incorrectly splits the message</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r20c1-t6">10058669</td><td align="left" headers="r20c1-t6 r1c2-t6"><code>ORA-01785</code> raised in sort-enabled classic reports when columns change</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r21c1-t6">10062523</td><td align="left" headers="r21c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE</code> API parameter typo</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r22c1-t6">10066270</td><td align="left" headers="r22c1-t6 r1c2-t6">Session State Protection report shows wrong value for Item Session State Protection</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r23c1-t6">10066324</td><td align="left" headers="r23c1-t6 r1c2-t6">Multiple tree regions on same page may result in incorrect tree data</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r24c1-t6">10069374</td><td align="left" headers="r24c1-t6 r1c2-t6">Pressing <code>ESCAPE</code> key sets value to jQuery based datepicker with time</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r25c1-t6">10070849</td><td align="left" headers="r25c1-t6 r1c2-t6">Interactive report filter with next day gives <code>ORA-00936: Missing expression</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r26c1-t6">10079075</td><td align="left" headers="r26c1-t6 r1c2-t6">Incorrect item layout on Create Calendar Region attributes page 4000:2006</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r27c1-t6">10090373</td><td align="left" headers="r27c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE</code> API parameters should not have <code>NULL</code> defaults</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r28c1-t6">10090518</td><td align="left" headers="r28c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_AGE</code> API removes incorrect messages</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r29c1-t6">10090652</td><td align="left" headers="r29c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_APP</code> API parameters should not have NULL default</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r30c1-t6">10090699</td><td align="left" headers="r30c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.REMOVE_DEBUG_BY_VIEW</code> API parameters should not have NULL defaults</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r31c1-t6">10091086</td><td align="left" headers="r31c1-t6 r1c2-t6">Flash 5 chart multiple Y axes only applied to first series of chart</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r32c1-t6">10092894</td><td align="left" headers="r32c1-t6 r1c2-t6">View <code>APEX_DEBUG_MESSAGES</code> sometimes returns incorrect <code>EXECUTION_TIME</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r33c1-t6">10092991</td><td align="left" headers="r33c1-t6 r1c2-t6">Debugging flag shows and saves wrong value in Edit Application Properties</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r34c1-t6">10093329</td><td align="left" headers="r34c1-t6 r1c2-t6"><code>APEX_DEBUG_MESSAGE.LOG_PAGE_SESSION_STATE</code> API does not show item values</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r35c1-t6">10093980</td><td align="left" headers="r35c1-t6 r1c2-t6">Navigation bar logout entry created with condition type CURRENT_LOOK_IS_1</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r36c1-t6">10095760</td><td align="left" headers="r36c1-t6 r1c2-t6"><code>ORA-20001: Error In MRU</code> in LOV in migrated tabular, form empty</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r37c1-t6">10100985</td><td align="left" headers="r37c1-t6 r1c2-t6">Enabling debug using <code>ENABLE_DEBUG_MESSAGES</code> API results in missing debug information</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r38c1-t6">10103359</td><td align="left" headers="r38c1-t6 r1c2-t6">Interactive report hangs search string exceeds allowed character limit</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r39c1-t6">10104409</td><td align="left" headers="r39c1-t6 r1c2-t6">Runtime installation becomes invalid when using <code>APXDEVRM.SQL</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r40c1-t6">10104883</td><td align="left" headers="r40c1-t6 r1c2-t6"><code>ORA-29279 SMTP permanent error</code> when using reporting period</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r41c1-t6">10107478</td><td align="left" headers="r41c1-t6 r1c2-t6">Region Display Selector attribute is ignored on import for certain region types</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r42c1-t6">10107616</td><td align="left" headers="r42c1-t6 r1c2-t6">Syntax error in SQL report results in <code>HTTP 404</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r43c1-t6">10107767</td><td align="left" headers="r43c1-t6 r1c2-t6">Condition type "NONE" for validation might raise error</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r44c1-t6">10108363</td><td align="left" headers="r44c1-t6 r1c2-t6">Flash 5 Map Animation option missing from Map Attributes page</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r45c1-t6">10108919</td><td align="left" headers="r45c1-t6 r1c2-t6">Flash 5 charts checksum only applied to Action link for last record of series</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r46c1-t6">10118507</td><td align="left" headers="r46c1-t6 r1c2-t6">Recently created dates can show in the future when using SINCE format mask</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r47c1-t6">10119451</td><td align="left" headers="r47c1-t6 r1c2-t6">Application export with authentication scheme using 'NOT', 'NOT' is lost on import</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r48c1-t6">10121357</td><td align="left" headers="r48c1-t6 r1c2-t6">Interactive report: when SELECT updated, existing columns of type timestamp are refreshed</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r49c1-t6">10124254</td><td align="left" headers="r49c1-t6 r1c2-t6">Create Application on Spreadsheet Wizard: Theme selector region too narrow</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r50c1-t6">10124263</td><td align="left" headers="r50c1-t6 r1c2-t6">Create Application on Spreadsheet Wizard: Final page icons not properly displayed</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r51c1-t6">10124268</td><td align="left" headers="r51c1-t6 r1c2-t6">Install application final page 'Update App' icon not proper</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r52c1-t6">10126550</td><td align="left" headers="r52c1-t6 r1c2-t6">Region display point preview popup does not work in German</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r53c1-t6">10149191</td><td align="left" headers="r53c1-t6 r1c2-t6">Dynamic actions: should show 'never' in Page Definition component view</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r54c1-t6">10149623</td><td align="left" headers="r54c1-t6 r1c2-t6">Page items of type select list, check box, and radio group should allow refresh</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r55c1-t6">10149957</td><td align="left" headers="r55c1-t6 r1c2-t6">Update text field item to number field item</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r56c1-t6">10150718</td><td align="left" headers="r56c1-t6 r1c2-t6"><code>APEX_INSTANCE_ADMIN.REMOVE_SAVED_REPORTS</code> should not remove primary default report</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r57c1-t6">10150816</td><td align="left" headers="r57c1-t6 r1c2-t6">Error on application search</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r58c1-t6">10154666</td><td align="left" headers="r58c1-t6 r1c2-t6">Interactive report chart displays incorrect decimal separator in non-english application</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r59c1-t6">10158459</td><td align="left" headers="r59c1-t6 r1c2-t6">Application Express Autocomplete is replacing ampersand with '&'</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r60c1-t6">10158747</td><td align="left" headers="r60c1-t6 r1c2-t6">Unexpected behavior with interactive report filtering with multi column LOV</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r61c1-t6">10162569</td><td align="left" headers="r61c1-t6 r1c2-t6">Search on 4000:1 includes SESSION_ID when it should not</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r62c1-t6">10162590</td><td align="left" headers="r62c1-t6 r1c2-t6">Search on 4000:1500 includes SESSION_ID when it should not</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r63c1-t6">10165864</td><td align="left" headers="r63c1-t6 r1c2-t6">Reader access not granted to user that logs in when running a PUBLIC Websheet</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r64c1-t6">10169594</td><td align="left" headers="r64c1-t6 r1c2-t6">Error message does not show up when editing process and shortcuts are used</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r65c1-t6">10174506</td><td align="left" headers="r65c1-t6 r1c2-t6">Bad region template selected on page 4000:48, ugly button wrapping issue</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r66c1-t6">10177937</td><td headers="r75c1-t6 r1c2-t6">Interactive report row text contains filter includes filter disabled column. To learn more, see <a href="http://www.oracle.com/technetwork/developer-tools/apex/application-express/402-patch-189110.html#CHDIHDIB">"Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns"</a></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r76c1-t6">10185693</td><td align="left" headers="r76c1-t6 r1c2-t6">Interactive report row filter type displays filter disabled column</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r77c1-t6">10185939</td><td align="left" headers="r77c1-t6 r1c2-t6">Add an API in <code>APEX_UTIL</code> to delete interactive report subscription</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r78c1-t6">10185978</td><td align="left" headers="r78c1-t6 r1c2-t6">Flash 5 scatter chart displaying incorrect marker in legend</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r79c1-t6">10188925</td><td align="left" headers="r79c1-t6 r1c2-t6">Import of application with access control supporting objects throws error</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r80c1-t6">10189958</td><td align="left" headers="r80c1-t6 r1c2-t6">Interactive report after refresh event sometimes causes processing GIF to not be hidden</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r81c1-t6">10190015</td><td align="left" headers="r81c1-t6 r1c2-t6">NV function raises <code>ORA-01722</code> if value contains group separator</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r82c1-t6">10195512</td><td align="left" headers="r82c1-t6 r1c2-t6">User granted create any table does not show up in spreadsheet data load</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r83c1-t6">10198879</td><td align="left" headers="r83c1-t6 r1c2-t6">Allow more than one email address in interactive report subscription</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r84c1-t6">10198889</td><td align="left" headers="r84c1-t6 r1c2-t6">Interactive report: subscription, format masks using substitutions are not supported</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r85c1-t6">10201943</td><td align="left" headers="r85c1-t6 r1c2-t6">Editing of page item fails if too many plug-ins are installed</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r86c1-t6">10202158</td><td align="left" headers="r86c1-t6 r1c2-t6">Page fails to load when many dynamic actions are defined on a page</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r87c1-t6">10202608</td><td align="left" headers="r87c1-t6 r1c2-t6">Team Development feedback, 4800:8000 does not search feedback column</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r88c1-t6">10202722</td><td align="left" headers="r88c1-t6 r1c2-t6">Editing Master Detail page in Create Application Wizard throws <code>ORA-20001: NO DATA FOUND</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r89c1-t6">10203473</td><td align="left" headers="r89c1-t6 r1c2-t6">In a Oracle Database upgrade release 11.2.0.2, <code>APXDBMIG.SQL</code> may show errors</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r90c1-t6">10203596</td><td align="left" headers="r90c1-t6 r1c2-t6">Change Theme Number - Wizard templates too narrow for buttons</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r91c1-t6">10205497</td><td align="left" headers="r91c1-t6 r1c2-t6">Flash 5 line chart 'Series type' defaults to bar instead of line</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r92c1-t6">10206259</td><td align="left" headers="r92c1-t6 r1c2-t6">Flash 5 Map Wizard displays incorrect images for North America and South America, Asia, and Oceania</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r93c1-t6">10206411</td><td align="left" headers="r93c1-t6 r1c2-t6">Flash 5 combined chart not displaying label and tooltip information for all chart series</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r94c1-t6">10206510</td><td align="left" headers="r94c1-t6 r1c2-t6">Classic report row highlighting function not working for all themes</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r95c1-t6">10207277</td><td align="left" headers="r95c1-t6 r1c2-t6">List of values report, 4000:421, does not search Query column</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r96c1-t6">10210711</td><td align="left" headers="r96c1-t6 r1c2-t6">Add new placeholder <code>#INTERNAL_MESSAGE#</code> to error page template</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r97c1-t6">10210802</td><td align="left" headers="r97c1-t6 r1c2-t6">DHTML list (IMAGE) with sublist does not work</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r98c1-t6">10215164</td><td align="left" headers="r98c1-t6 r1c2-t6">Restful Web service support does not escape values when posting</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r99c1-t6">10215440</td><td align="left" headers="r99c1-t6 r1c2-t6">Interactive report displays LOV in filter and highlight when it is disabled</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r100c1-t6">10218361</td><td align="left" headers="r100c1-t6 r1c2-t6">Editing filter on pseudo column in Websheet data grid displays 2 operator lists</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r101c1-t6">10219253</td><td align="left" headers="r101c1-t6 r1c2-t6">List of values report,4000:4110, does not search Query column</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r102c1-t6">10221310</td><td align="left" headers="r102c1-t6 r1c2-t6">Data Grid validation dialog has misleading title</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r103c1-t6">10222168</td><td align="left" headers="r103c1-t6 r1c2-t6">Websheet data grid filtering on Tag column has inconsistencies</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r104c1-t6">10223154</td><td align="left" headers="r104c1-t6 r1c2-t6">Data Grid Pseudo column filter and highlight information display in red when it should not</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r105c1-t6">10226951</td><td align="left" headers="r105c1-t6 r1c2-t6"><code>ORA-04030</code> encountered when displaying Flash chart in Oracle Database 11.2.0.2</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r106c1-t6">10228576</td><td align="left" headers="r106c1-t6 r1c2-t6">Interactive report email download and subscription send attachment in database character set</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r107c1-t6">10231413</td><td align="left" headers="r107c1-t6 r1c2-t6"><code>APEX_ITEM.SELECT_LIST_*</code> APIs behave incorrectly if <code>P_SHOW_NULL = YES</code></td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r108c1-t6">10232386</td><td align="left" headers="r108c1-t6 r1c2-t6">Multi-series chart does not display first chart</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r109c1-t6">10238450</td><td align="left" headers="r109c1-t6 r1c2-t6">Interactive report filter dialog raises a <code>404 "NO DATA FOUND"</code> error if page is submitted</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r110c1-t6">10240360</td><td align="left" headers="r110c1-t6 r1c2-t6">Flash 3 charts throw <code>ORA-01403</code> error if color schemes looks 6 or 7 used</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r111c1-t6">10244462</td><td align="left" headers="r111c1-t6 r1c2-t6">Confirmation page of Create Form on Web Service has buttons out of place</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r112c1-t6">10247924</td><td align="left" headers="r112c1-t6 r1c2-t6">Dynamic action When conditions does not work with shuttle, check boxes, or select list (with enabled Multi Select)</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r113c1-t6">10248011</td><td align="left" headers="r113c1-t6 r1c2-t6">Theme toolbar stretches after upgrading to Oracle Application Express 4.0.1 in Internet Explorer</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r114c1-t6">10252335</td><td align="left" headers="r114c1-t6 r1c2-t6"><code>ORA-20001: GET_BLOCK</code> when importing page which uses a not public user authentication scheme</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r115c1-t6">10254296</td><td align="left" headers="r115c1-t6 r1c2-t6">Access Migrations navigation region missing icons in generated applications</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r116c1-t6">10254433</td><td align="left" headers="r116c1-t6 r1c2-t6">Default theme should be set to theme 21 in Create Application Wizard</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r117c1-t6">10254660</td><td align="left" headers="r117c1-t6 r1c2-t6">Automatic Time Zone application with time zone at 0:00 loops forever</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r118c1-t6">10262671</td><td align="left" headers="r118c1-t6 r1c2-t6">Flash 5 chart series type item not displayed when page loaded using tree view</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r119c1-t6">10264946</td><td align="left" headers="r119c1-t6 r1c2-t6"><code>ORA-44003</code> occurs when Set Autocommit off in SQL Commands page</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r120c1-t6">10270216</td><td align="left" headers="r120c1-t6 r1c2-t6"><code>ERROR ERR-1016</code> / <code>ITEM_PREFERENCE</code> (Use item containing preference)</td></tr>
<tr align="left" valign="top"><td align="left" headers="r1c1-t6" id="r121c1-t6">10078661</td><td align="left" headers="r121c1-t6 r1c2-t6">Advisor fails with <code>ORA-20999 Unknown Type</code> if process type plug-in is used</td></tr>
</tbody></table>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com1tag:blogger.com,1999:blog-4378497715223662252.post-12314194164803897362010-11-04T12:17:00.000+05:302010-11-04T12:17:45.952+05:30APEX 4.0 pluginsHere are the list of site in which you can find the APEX 4.0 plugins:<br />
<ol><li><a href="http://www.apex-plugin.com/">http://www.apex-plugin.com/</a> </li>
<li><a href="http://www.oracle.com/technetwork/developer-tools/apex/plugins-155231.html">http://www.oracle.com/technetwork/developer-tools/apex/plugins-155231.html</a></li>
<li>Oracle APEX 4.0 Plugin Application: <a href="http://apex.oracle.com/pls/apex/f?p=654321">http://apex.oracle.com/pls/apex/f?p=654321</a></li>
</ol>Thanks............Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-48425523888219833102010-11-04T10:24:00.000+05:302010-11-04T10:24:34.674+05:30Happy Diwali and Prosperous New Year<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEArTyDSsPAYcBKXgxeYyxlHsbihmkZCXBME2bbXWJzsJjzIPfJyGc6pARtj0_1zCGNVWnmekILKWw1UOMrF4Yanh_JXIaTmAEr2W27CUFmEei5J32LGF_hcOJqI8tkZt65iYkJIFXpV6G/s1600/happy-deewali+%287%29.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="280" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEArTyDSsPAYcBKXgxeYyxlHsbihmkZCXBME2bbXWJzsJjzIPfJyGc6pARtj0_1zCGNVWnmekILKWw1UOMrF4Yanh_JXIaTmAEr2W27CUFmEei5J32LGF_hcOJqI8tkZt65iYkJIFXpV6G/s320/happy-deewali+%287%29.jpg" width="320" /></a></div><br />
Have a prosperous Diwali. Hope this festival of lights, brings you every joy and happiness. May the lamps of joy, illuminate your life and fill your days with the bright sparkles of peace, mirth and goodwill, because you are someone who deserves life's best and so much more. Have a joyous Diwali and new year.Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-76546910681507482922010-10-25T15:44:00.000+05:302011-12-07T14:04:26.287+05:30Oracle FIXED_DATE Parameter<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="color: black;">
<code>FIXED_DATE</code> enables you to set a constant date that <code>SYSDATE</code> will always return instead of the current date. </div>
<div style="color: black;">
<br /></div>
<div style="color: black;">
To undo a fixed date setting, specify <code>FIXED_DATE=NONE</code>. </div>
<div style="color: black;">
<br /></div>
<div style="color: black;">
This parameter is useful primarily for testing. </div>
<div style="color: black;">
<br /></div>
<div style="color: black;">
The value can be in the format shown above or in the default Oracle date format, without a time.</div>
<div style="color: black;">
<br /></div>
<div style="color: black;">
<b>Testing against a fixed date in Oracle?</b></div>
<div style="color: black;">
Testing against a fixed date is easy in Oracle.<span style="color: blue; font-family: Verdana; font-size: 12px; font-weight: 400; position: static;"><span class="kLink" style="font-family: Verdana; font-size: 12px; font-weight: 400; position: relative;"></span></span> Here is one example demonstrating use of FIXED_DATE parameter. <br />
<br />
Assuming you wanted to set a date Jan 1, 2010 in your database.</div>
<div style="color: black;">
<br /></div>
<div style="color: black;">
SQL> Select sysdate from dual ;</div>
<div style="color: black;">
This will display the current system date</div>
<div style="color: black;">
SQL> Alter System Set Fixed_Date='01-Jan-2010' ;</div>
<div style="color: black;">
SQL> Select sysdate from dual ;</div>
<div style="color: black;">
This will display the system date as '01-Jan-2010'</div>
<div style="color: black;">
The above Alter command can change the current sysdate to the date given.<br />
<br />
To change the sysdate to the original date.</div>
<div style="color: black;">
SQL> Alter System set fixed_date='none' ;</div>
<div style="color: black;">
SQL> Select sysdate from dual ;</div>
<div style="color: black;">
This will display the current system date</div>
</div>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-32354820885154995422010-10-20T11:32:00.003+05:302010-10-20T12:31:45.957+05:30Password strength meter in APEX<b>Step-1:</b><br />
On page <i><b>HTML Header</b></i> write the following code<br />
<br />
<blockquote><style><br />
#passwordStrength<br />
{<br />
height:10px;<br />
display:block;<br />
float:left;<br />
}<br />
.strength0<br />
{<br />
width:250px;<br />
background:#cccccc;<br />
}<br />
.strength1<br />
{<br />
width:50px;<br />
background:#ff0000;<br />
}<br />
.strength2<br />
{<br />
width:100px; <br />
background:#ff5f5f;<br />
}<br />
.strength3<br />
{<br />
width:150px;<br />
background:#56e500;<br />
}<br />
.strength4<br />
{<br />
background:#4dcd00;<br />
width:200px;<br />
}<br />
.strength5<br />
{<br />
background:#399800;<br />
width:250px;<br />
}<br />
</style></blockquote><b>Step-2:</b><br />
On password item <b>P10_PASSWORD</b><br />
<br />
<i><b> HTML Form element attribute:</b><u> </u></i>onkeyup="return passwordChanged();" <br />
<br />
<b>Step-3:</b><br />
Create an item <b>P10_PASSWORD_STRENGTH</b> on right side of password item.<br />
<br />
<b><i>Display As:</i></b> Display as text(escape special characters, does not save state)<br />
<i><b>Pre Element Text: </b></i><br />
<blockquote><script language="javascript"><br />
function passwordChanged(){<br />
var pwd = document.getElementById('P10_PASSWORD_STRENGTH');<br />
var password = document.getElementById("P10_PASSWORD").value;<br />
var desc = new Array();<br />
desc[0] = "Very Weak";<br />
desc[1] = "Weak";<br />
desc[2] = "Better";<br />
desc[3] = "Medium";<br />
desc[4] = "Strong";<br />
desc[5] = "Strongest";<br />
var score = 0;<br />
if (password.length > 6) score++;<br />
if ( ( password.match(/[a-z]/) ) && ( password.match(/[A-Z]/) ) ) score++;<br />
if (password.match(/\d+/)) score++;<br />
if ( password.match(/.[!,@,#,$,%,^,&,*,?,_,~,-,(,)]/) ) score++;<br />
if (password.length > 12) score++;<br />
document.getElementById("passwordDescription").innerHTML = desc[score];<br />
if (password.length==0) {<br />
document.getElementById("passwordDescription").innerHTML = 'Password not entered';<br />
} </blockquote><blockquote> document.getElementById("passwordStrength").className = "strength" + score; </blockquote><blockquote>}<br />
</script></blockquote><i><b>Post Element Text: </b></i><br />
<blockquote><div id="passwordDescription">Password not entered</div></blockquote><blockquote><div id="passwordStrength" class="strength0"></blockquote><blockquote></div></blockquote><br />
<b>Demo Example:</b> <a href="http://apex.oracle.com/pls/apex/f?p=KP:PSM">http://apex.oracle.com/pls/apex/f?p=KP:PSM</a><br />
<br />
Refer <a href="http://www.codeassembly.com/How-to-make-a-password-strength-meter-for-your-register-form">http://www.codeassembly.com/How-to-make-a-password-strength-meter-for-your-register-form</a> for more info.<br />
<br />
<b>Final output:</b><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfAMgfG16Slpv2l3pCriJxyp8c5Hat51l25iBgcMS5_Y_Z-ohznRJ3F5G-lFNlNvLP3fHvrxjuT6Uo659Fyn21WbQ1ppkZcoyYlKCk7yjQjWOE-iXXufB3raLACu2Nyq2lkF0LExocg4aU/s1600/Password+1.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="125" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfAMgfG16Slpv2l3pCriJxyp8c5Hat51l25iBgcMS5_Y_Z-ohznRJ3F5G-lFNlNvLP3fHvrxjuT6Uo659Fyn21WbQ1ppkZcoyYlKCk7yjQjWOE-iXXufB3raLACu2Nyq2lkF0LExocg4aU/s400/Password+1.JPG" width="400" /></a></div><br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTCCEIxOVX2lmghN5e6G4lY-nv9wLoC9hatxC2BzDyJmKXB6V5V0Mh9aHw0T6jEoMWOVoeYb2ZvyV0GTeQhY_iPgqG5a_x6RsEYfAplIhUK6KIL4pWcuPDHD3A5BPiIOXPgFiWTp7tMmRD/s1600/Password+2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="127" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTCCEIxOVX2lmghN5e6G4lY-nv9wLoC9hatxC2BzDyJmKXB6V5V0Mh9aHw0T6jEoMWOVoeYb2ZvyV0GTeQhY_iPgqG5a_x6RsEYfAplIhUK6KIL4pWcuPDHD3A5BPiIOXPgFiWTp7tMmRD/s400/Password+2.JPG" width="400" /></a></div><br />
Thanks<br />
<br />
<table border="0" cellpadding="0" class="htmldbtiny" summary=""><tbody>
<tr><td align="right"><br />
</td><td><a href="http://lab.octalsoft.com:8000/apex/f?p=4000:4311:2049190629569836::::F4000_P4311_ID:15493709863571005" title="Label="><br />
</a></td><td><br />
</td></tr>
</tbody></table>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com4tag:blogger.com,1999:blog-4378497715223662252.post-57089149963550041072010-10-16T11:40:00.000+05:302010-10-16T11:40:10.504+05:30Some usefull plugins For Oracle APEX 4.0Some usefull plugins from <a href="http://www.apex-plugin.com/">http://www.apex-plugin.com/</a> For Oracle APEX 4.0<br />
<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/text-field-with-masked-input.html">Text Field with Masked Input</a><br />
This is an APEX integration of the jQuery Masked Input Plugin created by Josh Bush (www.digitalbush.com). It allows you to force data input in a fixed format.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/skillbuilders-ir-header-float.html">SkillBuilders IR Header Float</a><br />
<span id="sobi2Details_field_description"><span id="sobi2Details_field_description">Interactive Reports are powerful reports in APEX that allow end users to customize reports to meet their needs. However, as with most other reports, viewing many rows at once requires users to scroll down the web page. As users scroll down, the report headers scroll out of site which can cause users to lose the context of the data being viewed – especially if the data involves lots of data and/or numbers.</span></span><br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/region-plugin/google-directions.html">Google Directions</a><br />
This plugin provides the Google driving directions, route map, estimated distance and travel time based on two provided locations. This is an adaptation of Botoka's Google Map.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/form-validator.html">Form Validator</a><br />
This dynamic action plug-in provides client-side form validation. The validation rules are based on the Apex Dictionary, like required items, number items (min/max values) and date items.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/region-plugin/mbndata-tabs.html">MBNDATA Tabs</a><br />
Region plugin using jquery tabs.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/dynamic-action-plugin/skillbuilders-save-before-exit.html">SkillBuilders Save Before Exit</a><br />
Have you ever filled out a form and accidentally left the page without saving your work? It is actually quite easy to do. Thankfully, browsers have features to help prevent this from happening. The problem, however, is that taking advantage of those features can be quite difficult - until now.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/region-plugin/sumneva-drag-and-drop-report.html">Sumneva Drag & Drop Report</a><br />
This plug-in creates an AJAX enabled Drag & Drop Report from a SQL Query (and a few other bits and bobs) supplied by the user.<br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/skillbuilders-schedule.html">SkillBuilders Schedule</a><br />
<span id="sobi2Details_field_description2"><span id="sobi2Details_field_description2">Event scheduling is a common task that developers repeatedly face when creating applications. The types of events can vary greatly as can their configuration options. Some events are simple, occurring only once while others are more complex and can repeat indefinitely.</span></span><br />
<br />
<a href="http://www.apex-plugin.com/oracle-apex-plugins/item-plugin/tokenizing-autocomplete.html">Tokenizing-Autocomplete</a><br />
A facebook style autocomplete text field.Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-28805450182494930432010-08-31T11:30:00.000+05:302010-08-31T11:30:42.835+05:30Set OR Get apex item valueProcedure to set the apex item value <br />
<br />
create or replace PROCEDURE PROC AS<br />
BEGIN<br />
APEX_UTIL.set_session_state<br />
(<br />
p_name => 'P1_X',<br />
p_value => 'KARTIK');<br />
END PROC1;<br />
<br />
Here P1_X is the item name which is unique in APEX.<br />
<br />
And call this procedure or also function in apex process.<br />
<br />
Same way you can get the apex item value using get_session_state function:<br />
<br />
<pre class="oac_no_warn" xml:space="preserve">APEX_UTIL.GET_SESSION_STATE (
p_item IN VARCHAR2)
RETURN VARCHAR2;</pre>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com1tag:blogger.com,1999:blog-4378497715223662252.post-24558736265901947682010-08-21T14:47:00.000+05:302010-08-21T14:47:10.369+05:30New feature in APEX Listener 1.0.1There's a new feature in APEX listener 1.0.1<br />
<br />
<a href="http://krisrice.blogspot.com/2010/08/getting-running-with-apex-listener-101.html">http://krisrice.blogspot.com/2010/08/getting-running-with-apex-listener-101.html</a><br />
<br />
This feature is great for developer.Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-14480857821378279812010-08-04T12:49:00.001+05:302010-08-04T12:49:47.392+05:30Installing APEX 4 on Windows Server 2003 64 bit edition with Oracle Database 11gThis tutorial article and it’s associated video will help guide you through the process of installing APEX version 4.0 in a Windows Server 2003 64 bit OS environment with Oracle Database 11g R2 installed.<br />
<br />
<div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"></div><div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"></div><div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"></div><div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"></div><div style="background-color: transparent; border: medium none; color: black; overflow: hidden; text-align: left; text-decoration: none;"><br />
<object data="http://www.youtube.com/v/pLK1r8UY42I&amp;rel=0&amp;fs=1&amp;showsearch=0&amp;showinfo=0" height="344" id="vvq-2000-youtube-1" style="visibility: visible;" type="application/x-shockwave-flash" width="425"><param name="wmode" value="opaque"><param name="allowfullscreen" value="true"></object><br />
<br />
Read more: <a href="http://www.mandsconsulting.com/installing-apex-4-to-server-2k3-x64-and-oracle-11g-video-training#ixzz0vcS8PoiK" style="color: #003399;">http://www.mandsconsulting.com/installing-apex-4-to-server-2k3-x64-and-oracle-11g-video-training#ixzz0vcS8PoiK</a></div>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-45353316699418347112010-06-24T10:54:00.000+05:302010-06-24T10:54:24.269+05:30Oracle Application Express Release 4.0Oracle Application Express Release 4.0 was released on June 23, 2010. You can now select to download All languages (for running Application Express in one of our translated languages) or English-only (can only run Application Express in English). The English-only version will still support translating the applications that you build into other languages.<br />
<br />
Download it from here<br />
<br />
<a href="http://www.oracle.com/technology/products/database/application_express/download.html" linkindex="519">http://www.oracle.com/technology/products/database/application_express/download.html</a>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-38019388803843025062010-03-15T14:53:00.000+05:302010-03-15T14:53:31.796+05:30Page's item value not set when click on delete from formIn Form with report page when we delete the record from the form it will redirect to the parent report in which the page's item value will be set that would be written on page branch.<br />
<br />
But when we delete the record the page's item not set<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmkQ3d0KrvVjLIfwbU4eiKJjtaV1SVLS4mPxMOoM_gJw-F-uSvgoaPKp42pEdY11gs3VbYGM4Fx9UROdAvT7fKEc1e-5MkQdr52m3e-kl-ZLpJy4GyT5bExfDH45UitwL1EnTF8ER2yxQw/s1600-h/1.JPG" imageanchor="1" linkindex="21" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjmkQ3d0KrvVjLIfwbU4eiKJjtaV1SVLS4mPxMOoM_gJw-F-uSvgoaPKp42pEdY11gs3VbYGM4Fx9UROdAvT7fKEc1e-5MkQdr52m3e-kl-ZLpJy4GyT5bExfDH45UitwL1EnTF8ER2yxQw/s320/1.JPG" /></a></div><br />
The reason is the reset page process will be called on delete button.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKk5AeIgWHI1xCCShQ33A2DutqVqIKRnDt8CVH0kdCcS4eUtXYi-eYdUZsGYqTs20fPlr-UlwR8_QN5y2QVhEaAjOeKTbJyKebQo9dajtaXOsgUWczwpIDtFOOYGo4Mh7Oq7hktGxgh-JW/s1600-h/2.JPG" imageanchor="1" linkindex="22" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgKk5AeIgWHI1xCCShQ33A2DutqVqIKRnDt8CVH0kdCcS4eUtXYi-eYdUZsGYqTs20fPlr-UlwR8_QN5y2QVhEaAjOeKTbJyKebQo9dajtaXOsgUWczwpIDtFOOYGo4Mh7Oq7hktGxgh-JW/s320/2.JPG" /></a></div><br />
So avoid this situation Change "Condition type:" to "Never" of that "reset page" process.Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-26602374361248088892010-02-01T11:18:00.001+05:302010-02-01T11:18:58.342+05:303 IdiotsSaari umr hum<br />
coding main mar gaye<br />
Ek pal to ab humein jeene do<br />
jeene do<br />
<br />
Saari umr hum<br />
coding main mar gaye<br />
Ek pal to ab humein jeene do<br />
jeene do<br />
<br />
Na na na….Na na na….Na na na….Na na nana na….<br />
<br />
Give me some flight<br />
Give me some train<br />
Give me another chance<br />
I wanna go home once again<br />
<br />
Give me some flight<br />
Give me some train<br />
Give me another chance<br />
I wanna go home once again<br />
<br />
Kandhon ko laptop<br />
Ke bojh ne jhukaya<br />
<br />
Client se jhoot bolna tho khud<br />
Manager ne sikhaya<br />
<br />
C-3 ya D-3 rating laaoge to chhuti, varna kismat futi<br />
Code kar kar ke pada Ungaliyon pe<br />
JAVA, ORACLE aur PERL ka chaala<br />
<br />
Is Project ne to sala poora..<br />
Poora bheja pakka daala<br />
<br />
Career to gaya<br />
GF bhi gayi<br />
Ek pal to ab humein<br />
jeene do jeene do<br />
<br />
Career to gaya<br />
GF bhi gayi<br />
Ek pal to ab humein<br />
jeene do jeene do<br />
<br />
Saari umru hum<br />
coding main jee liye<br />
Ek pal to ab humein jeene do<br />
jeene do<br />
Na na na….Na na na….Na na na….Na na nana na….<br />
Give me some flight<br />
Give me some train<br />
Give me another chance<br />
I wanna go home once again<br />
Give me some flight<br />
Give me some train<br />
Give me another chance<br />
I wanna go home once again<br />
Na na na….Na na na….Na na na….Na na nana na….<br />
Na na na….Na na na….Na na na….Na na nana na….Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0tag:blogger.com,1999:blog-4378497715223662252.post-6271488882566479282009-12-21T14:32:00.001+05:302009-12-21T14:32:53.601+05:30Oracle Application Express 4.0 Early Adopter is now available.<span class="bodycopy"> Please fill out the survey and request a workspace on our hosted instance @ <b><a href="http://tryapexnow.com/">http://tryapexnow.com</a></b>.<br />
<br />
This Early Adopter is not production ready and some new features may contain bugs or incomplete functionality.<br />
Websheets is not yet available in the Early Adopter. Our plan is to produce an updated release (Early Adopter Phase II) once Websheets is ready to be tested.<br />
The new theme used throughout the Application Builder is still a work in progress, especially in respect to Internet Explorer. Therefore we have disabled access from IE at this stage.<br />
Online Help has not yet been updated and does not include any new features. An application describing all the new features will be available shortly.<br />
<br />
Please provide feedback directly from within the Application Builder.</span>Kartik Patelhttp://www.blogger.com/profile/03028628507499062389noreply@blogger.com0