SMART4Solutions
  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy

Database

APEX Database JoelKallmanDay

ORA-06502: When loading data in the APEX data-loader

My contribution to this years contribution to #JoelKallmanDay Recently I created a data-load within APEX to load about 3500 lines of excel-sheet into a temporary table. I created the table for receiving the data using the Data Workshop, as shown in the image. I now had a neat little table Read more…

By Richard Martens, 1 year11 October 2021 ago
Database OraCloud

OCI connections to multiple Autonomous Transaction Databases in the Oracle Always Free cloud

I still use PL/SQL developer to work in our Oracle Databases. It is a tool I’ve been using for years and old habits seldom die.. In fact Pl/SQL developer is the only sound reason I have parallels desktop installed on my Mac. 🙂 PL/SQL developer connects to the database using Read more…

By Richard Martens, 3 years8 October 2019 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
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 (12)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (4)
  • Presentations (2)
Archives
  • November 2022
  • September 2022
  • 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 (12)
  • API (1)
  • Automation (1)
  • Database (4)
  • Events (3)
  • JavaScript (3)
  • JoelKallmanDay (1)
  • OraCloud (2)
  • PL/SQL (4)
  • Presentations (2)

  • Blog
  • Presentations
  • SMART4Solutions
  • Cookie Policy
Hestia | Developed by ThemeIsle
This website uses cookies to improve your experience. We'll assume you accept this policy as long as you are using this websiteAcceptView Policy