SMART4Solutions
  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy

October 2018

APEX PL/SQL

On APEX LOV’s and how to define their queries

The goal in defining LOV queries is to have them stored in a compiled way, having the benefit of database dependencies and making use of the SQL optimizer.

By Richard Martens, 4 years13 October 2018 ago
Events

SIOUG 2018

October 15 – 16, 2018 Portoroz, Slovenia The MakeIT18 conference will be held on October 15 and 16, 2018 at Portus Portus in Portorož, Slovenia. We expect over 300 participants. View Details

By Chris Jansen, 4 years12 October 2018 ago
Database

Make tomcat wait until oracle database is available

Recently I’ve been installing the OATOA (Oracle APEX on Tomcat with ORDS behind Apache) stack a number of times on both Oracle Linux 7 and CentOS7. In the past this was no problem, Tomcat came up and a request to http://myserver:8080/ords/ gave me the expected APEX login screen. However since Read more…

By Richard Martens, 4 years5 October 2018 ago
APEX Automation JavaScript

Automating APEX using Node.js and Puppeteer

Did you know that Chrome now ships with the feature Headless Chrome it is a tool for automated testing. For example, you may want to run some tests against a real web page, create a PDF of a page, or just inspect how the browser renders an URL, you can Read more…

By Chris Jansen, 4 years5 October 2018 ago
Database

The request could not be mapped to any database

Today I figured out to my shame that the mentioned error by ORDS 3 has a really, REALLY simple cause… the password was expired. Logging in (using SQL-plus) revealed this elegantly: The second one of course did the trick. Regards, Richard

By Richard Martens, 4 years5 October 2018 ago
Categories
  • APEX (10)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (3)
  • Presentations (2)
Archives
  • April 2022
  • October 2021
  • July 2021
  • November 2019
  • October 2019
  • May 2019
  • November 2018
  • October 2018
  • March 2016
Follow Us On Twitter
  • Richard Martens
  • Sergei Martens
  • Robert Van Leenders
  • Kevin Rütten
  • Chris Jansen
Interesting Links
  • SMART4Apex
  • SMART4Branding
  • SMART4Solutions
  • Privacy Policy
Categories
  • APEX (10)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (3)
  • Presentations (2)

  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy
Hestia | Developed by ThemeIsle
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.

Settings Reject Accept Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy