Christoph's 2 Cents

ORA-12545 When running Oracle inside Docker

July 11, 2018 cruepprich 0 Comments devops, docker, oracle, oracle xe

When trying to make an http request from my Oracle database running inside a Docker container, I received the following error:

Oracle Developement

Building a Oracle 12.2 Docker Image

July 5, 2018July 5, 2018 cruepprich 0 Comments

…or a 12.2…or a 11.2 image… Docker installation instructions for RHEL 7. To quickly build an Oracle database Docker image, you

Oracle Developement

Reblog: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7

March 29, 2018 cruepprich 0 Comments

Here is a nice guide for a full-stack APEX configuration: http://dsavenko.me/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-introduction/

Oracle Developement

Quick & Dirty: Populate number array from string.

March 13, 2018June 20, 2018 cruepprich 3 Comments

Here is a quick way to convert a list of colon separated numbers into a number array:

declare 
  l_list_of_numbers varchar2(32767) := '1:2:3'; 
  l_string_array apex_application_global.vc_arr2; 
  l_number_array apex_application_global.n_arr; 
begin 
  l_string_array := apex_util.string_to_table(l_list_of_numbers); 
  select * bulk collect 
  into   l_number_array 
  from   table(l_string_array); 
   
  for idx in 1..l_number_array.count 
  loop 
    dbms_output.put_line(l_number_array(idx)); 
  end loop; 
end;