Sometimes when you’re writing code you can encounter the situation only one session / thread may execute it (the code) at a time. This is commonly referred as a “Critial Section“. How do you solve such a problem within the Oracle Database?
Continue reading “Have only one session execute code (Critical section)”Category: Oracle
Oracle thingies
Debugging via Dbms_Pipe
When running code you sometimes have the need to debug the progress of the statements. One way is to use a table and write your debug output into it by means of an autonomous transaction. But sometimes it can be easier to just hand the debug info to a different session. Say hi to Dbms_Pipe…
Continue reading “Debugging via Dbms_Pipe”Quickstart Apex with docker-compose v2
As I read an article about Oracle providing version 23c “for free to developers” (https://blogs.oracle.com/database/post/oracle-database-23c-free) I wondered if it was usable for a quick deploy of Apex. As ORDS has been updated as well it turns out that needed some tweaking…
Continue reading “Quickstart Apex with docker-compose v2”Running Oracle on MacBook M2
As I am an Oracle consultant I sometimes want to try things on a local instance. My normal way of working is to fire up a virtual machine or docker instance with the Oracle database and try the things I want to try.
Continue reading “Running Oracle on MacBook M2”Export data in handy formats using SQLDeveloper
Just a small techtip
Sometimes you want to export table data. SQLDeveloper can help you with that with a few formats which are built-in and are callable via a simple hint within your SQL statement.
Continue reading “Export data in handy formats using SQLDeveloper”Using unicode characters in PL/SQL
Sometimes you need to use unicode characters in messages / strings you output from PL/SQL code. However sometimes the automatic installation procedures of a customer might use a different or weird character-set when installing your code into the database. What happens is that the character within the source (in a constant for example) becomes mangled and appears as a “character not recognised question mark” in the output.
Continue reading “Using unicode characters in PL/SQL”Quickstart Apex with docker-compose
Sometimes you have the need to quickly spin up an Oracle Apex install to test something out or to just have a “clean” instance. Luckily this is quite easily done with Docker.
Continue reading “Quickstart Apex with docker-compose”Quick submission of concurrent program in selfservice
Submitting a concurrent program via selfservice can be quite cumbersome for users. It’s possible to make their day a bit better by shortening the submission procedure…..
Continue reading “Quick submission of concurrent program in selfservice”Using FNDLOAD from within Ebs
When you want to copy developed (functional) items from one instance to another, for example from the acceptance environment to production, FNDLOAD is a great tool to use. Everything is copied in an instant and you’re quite sure that it is exactly as the set-up you had in the other environment.
Continue reading “Using FNDLOAD from within Ebs”Creating text files with bursting
For the customer i had to create a solution which generated PDF files out of the data of the appraisal (HR) module. These files need to be imported into another system so another requirement was the fact that meta-data has to be provided. The meta-data needs to be provided as a flat text-file.
Continue reading “Creating text files with bursting”