Recently, I tried to found the complex solution for using Oracle Wallets to connect SSL (HTTPS) service in Oracle Database 12c. I didn't find any and because there are a small changes between Oracle 11g and 12c releases I decided to wrote this blog post. This blog supposes that you have Oracle Database 12c installed and you have admin rights to this database instance. Get Site Certificates In order to make connections to a secured resources, we need to get necessary certificates. The easiest way to do this is using a browser (Chrome and Firefox browsers are preferred). The example below uses the Chrome browser (note: in Chrome version 50 the Connection tab has been dropped when you click the (Green) Padlock for site security info). Using the browser, go to the URL you want to access from PL/SQL. For our example "https://www.redhat.com". Than open the developer toolbar (press F12 or Ctrl+Shift+I) and click on the "Security" tab. Click the "View certi
In one of my project, I try to find the solution for fact that the user unintentionally submit the page more than once. Let's suppose that you have two buttons on one page both of them run submit after click on it. This submit run similar DML in DB. If you have poor internet connection to application server you got chance to click on both buttons before page is refreshed. Apex provides an attribute on page-level "Allow duplicate page submissions page". As the name implies, this attribute determines whether a single page can be submitted more than once. By default, this attribute is set to "Yes - Allow page to be re-posted". User than submit the same page twice. Therefore, in most cases this attribute should be disabled by setting it to "No - Prevent page from being re-posted". The disadvange of this solution is that users are redirected to error page every time a re-post occurred and got an error " ERR-3331 This page was already submitted and