Oracle Blog

Storm Petrel strives to share our knowledge and experience with Oracle and Oracle APEX with our peers in the development community.

  • PLSQL Compress BLOB

    PLSQL compress blob - now even easier with APEX_ZIP. Read more ...

  • Oracle PL/SQL AWS S3

    Amazon Web Services (AWS) Simple Storage Solution (S3) has upgraded its application programming interface (API) to support HTTPS. This upgrade involved a redesign of the authentication process at AWS. The authentication process now involves authenticating the user and verifying the canonical request made to AWS S3.

  • Oracle PLSQL SMS and MFA

    Using multifactor authentication with Oracle APEX is the right thing to do, in some cases. Read on...

  • APEX Error Code apex.error.internal request-plugin

    Exporting then importing an Oracle APEX 5.1 application with a newer-style JET report generated an error indicating a problem with a plug in.

  • Oracle APEX Accessibility

    VPAT, Section 508, WCAG all deal address improving access to software. Oracle APEX has the tools, developers should include the techniques. What do we need steer closer and close to the various guidelines that deal with improving Oracle APEX accessibility?

  • Synchronize APEX RESTful Services

    How do we synchronize APEX RESTful service? This step has become mission critical now that all of our reports are generated with APEX Office Print (AOP).

  • Calendar Invitations

    Calendar invitations are crude text files that follows standards established in RFC 5545. Creating these files from within Oracle PL/SQL requires understanding the rules.

  • Orace APEX_APPLICATION Synonyms

    Oracle APEX_APPLICATION synonyms are worth exploring.

  • AOP Text Formatting

    While I love Oracle Application Express, I have experienced frustration with generating stunning printed material. APEX Office Print (AOP) has simultaneously expanded our team’s capabilities while reducing our effort. That’s a tool! Rather, that is the definition of a great tool.

  • Oracle APEX Page Type

    Have you ever just needed to know what Oracle APEX page type or page mode you are on?

  • Convert RGB to Hex with PLSQL

  • Planning Page Numbers

    There are numerous advantages for planning page numbers in Oracle Application Express. The more obvious is that you can group pages and order then based on function. Finding a page from a list of pages becomes easier with a plan. Your list looks organized. Well, it is organized. The Christopher Columbus style stumbling ends and confident navigation begins.

  • Media Capture from Phone with Oracle APEX

    Do you want to capture images, video or audio into an APEX application directly from your phone?

  • Data Preparation for AOP

    The team at Storm Petrel are enthusiastic about using AOP (APEX Office Print) for developing high-quality and professional reports directly from Oracle Application Express. Our expectation is that with AOP, the cost of developing terrific looking reports will be reduced (significantly?!) and that we will gain greater flexibility with report layout. Data preparation for AOP has a few tricks.

  • Synchronize Sequence with Primary Key

    Keep sequences synchronized with primary keys when moving schema tables (impdp, expdp)

  • Oracle APEX 5 Sentry Function

    I decided to explore the Oracle APEX 5 Sentry Function that I started seeing in application parameters. On a newer custom application, I obediently copied the suggested code into a package. I put my trust into the great team at Oracle and nothing bad happened. That didn’t actually resolve my curiosity about what the thingy does and why is it is good for me.

  • Help

    Adding help to an application advances the professional look and polish of an application. Furthermore, adding help text to pages and page items forces the development team to stand back from their own work and view the effort from the user’s perspective. Oracle APEX provides several tools facilitate the process. It is our job to put them into place and get them working.

  • How NOT to Apply for a Job

    Dear Applicant - Your words, actions, and efforts will guarantee a immediate dismissal of your application for a position. Want the secret? Read on… If you don’t care (well, you’ve already stopped reading… so I won’t bother)

  • APEX_ITEM.Check_box2

    Oracle APEX 5 Classic Report Templates are worth exploring and incorporating into your applications. Discovering their power requires a bit of effort. There are few blogs and the APEX 5 on-line manual does not seem to address these tools. to discover the required columns and the features that the APEX team tucked in there for us. The example below has been created with the Universal Theme (42) with a Classic Report. The Classic Report Region Appearance Template is “Hero” and the Classic Report Attributes Appearance Template is “Alerts”.

  • Oracle APEX 5 Classic Report Templates

    Oracle APEX 5 Classic Report Templates are worth exploring and incorporating into your applications. Discovering their power requires a bit of effort. There are few blogs and the APEX 5 on-line manual does not seem to address these tools. to discover the required columns and the features that the APEX team tucked in there for us. The example below has been created with the Universal Theme (42) with a Classic Report. The Classic Report Region Appearance Template is “Hero” and the Classic Report Attributes Appearance Template is “Alerts”.

  • Oracle APEX 5 as REST Client (Part 2)

    This entry serves as a continuation of a 06DEC15 entry - Oracle APEX 5 as REST Client.

  • Oracle MailChimp Package

    Storm Petrel developed an Oracle MailChimp package that integrates with MailChimp, the email/marketing services. The package, written in PL/SQL, is essentially an Oracle interface to your or your customer’s MailChimp data. The package, itself, does not contain any user interface. It is written to augment applications that may benefit from linking to an email marketing tool.

  • Oracle APEX 5 as REST Client

    Combining APEX_WEB_SERVICE.MAKE_REQUEST and the APEX_JSON toolkit, writing an interface to an external application has become a bit easier for Oracle APEX developers. I encourage folks to go play and share what they find. A few weeks ago when wanted to write an Oracle API for MailChimp, I floundered for days. Vincent Morneau (@vincentmorneau) with Insum Solutions coached me. Together, we found where I had gone wrong, put the tools I needed in my hands and off we went. With these tools, writing an interface to anything with a REST API become approachable.

  • Oracle APEX Multifactor Authentication

    The United States Office of Personnel Management is notifying 2.7 million people that their data were stolen. The blame lays at the feet of the people responsible for these data. While the ultimate responsibility rests with the executives who did not fund investment into data security, I shoulder that responsibility daily.

  • APEX5 Font-Awesome Letters

    In one of our applications, we have a thing called a PW. Throughout the industry (disaster response, that is), a PW is a real thing. While once-upon-a-time it was a worksheet in Excel describing a FEMA funded project, the “what” has morphed well beyond. I need an icon for PW. When I started this morning, I would have accepted “P”. I was not going to accept the PayPal “P”. With this trick, any of us can have standard letters and numbers present themselves as icon on APEX5 lists and navigation menus.

  • Oracle APEX Authentication

    In this blog entry, I am exploring the validity of an old decision. Our team avoided using APEX users (workspace users) in our commercial Oracle applications because we wanted to store significantly more information with the user data than is permitted with the default APEX authentication process. When engaging Oracle Application Express custom authentication and strong password hashing, APEX provides developers with many of the same functions found with the internal processes. We found good documentation in the community about creating custom authentication processes. Is the decision to use custom authentication still valid? Or should we incorporate the APEX internal tools?

  • Notification message checksum content error on Login

    “Notification message checksum content error on Login” that appears on failed authentication within Oracle APEX5 (APEX 5.0 and APEX 5.0.1). I found a few postings about challenges with Apache and such. We chased that rabbit around the brier patch a while and quit when finding it Apache and Listeners are not the problem. The wicked smart DBA at Insum Solution suggested running a test that didn’t use Apache. Apache and web-interfacing technology did not alter the results.

  • APEX5 Pagination

    The Previous Page, Next Page, and Reset Page buttons will no longer be generated automatically when creating regions, for example creating a Form and Report on a table. You can manually recreate similar buttons, and enter the appropriate button behavior.Oracle APEX5 Documentation

  • APEX5 Upload BLOB with File Browse

    WWV_FLOW_FILES is dead. Long live APEX_APPLICATION_TEMP_FILES. Frankly, I like the name and the function.

  • What is height of multi-line cell in PL/PDF?

    There went another seven hours of my day. I encountered fouled page break with a multi-line cell. In this case, I was working on an invoice. The narrative/description displays in a multi-line cell. You know the drill, the first line has the date, qty, rate, extended, etc. The second line of the detail section contains just a lengthy narrative or description. It worked fine until the page break needed to occur in the middle of the multi-line cell using PL/PDF

  • Error Trace Tool for PL/SQL

    Last night we got hit with a production error where something in our production schema will calling back to something in our development schema. It caused really interesting problems. I had at my hand these tools that I’d already put into our work. Initially it didn’t work. When the errors were generated, Oracle rolled back so my error trapped data was blank. I added a commit. That was solved. Then my challenge was finding the source of my problem.

  • Oracle APEX AWS S3

    We are moving our commercial APEX applications from shared hosting to Amazon Web Services. Due to the constraints of APEX, we setup our own Oracle forgoing RDS. We ran into two problems with AWS S3 problems - Request Time vs Current Time and S3 bucket names.

Blog Posts Sorted By Category

Apex features

Apex reports

Aws s3

Apexofficeprint

Debugging

Font-awesome

Jobs

News

Oracle apex

Oracle apex 5

Oracle apex 5 authentication

Oracle apex 5 login error

Oracle apex 5 media capture

Oracle apex 5 pagination

Oracle apex 5 planning page numbers

Oracle apex accessibility

Oracle apex error

Oracle apex help page

Oracle apex multifactor authentication

Oracle apex restful

Oracle plsql

Oracle plsql aws s3

Plpdf

Plsql

Plsql api

subscribe via RSS