I have been an enthusiastic APEX fan for years. And like every APEX fan, I also have a workspace on APEX. https://apex.oracle.com.
Here Oracle offers the possibility to get to know APEX and to host small demo projects. You can switch and manage within your workspace as you like. What Oracle does not offer here, however, is external access to the database / schema with an IDE or SQLPlus. Of course, otherwise Oracle would have to publish the port of the DB listener.
Recently I read an article by Peter Raganitsch. Link: http://www.oracle-and-apex.com/streaming-flat-file-data-into-database/ Here he describes how to upload and evaluate log files via RESTful Service. When I read that, I had an idea. Why shouldn’t this also work with my source code?
Continue reading “RESTful Deployment”
In my current project I use an interactive grid on one page. When you click on a row, i. e. select it, a report is displayed below the grid that displays this data set. The editing of the data set is realized in a modal dialog. If it is closed, the report including the currently selected line in the grid should be updated.
Continue reading “Interactive Grid – Update current row only”
in one of my current Apex projects I have to show a mini calendar and mark certain days there. Unfortunately there is only the option to mark exactly one date in APEX. After a little Google research I came across the following article:
So what is done here is the following:
Continue reading “JQuery datepicker with multiple tagged days”
It’s desperate. I moved the trace export for a customer from the client to the server via forms. No problem on my Windows7 computer. The logic is actually quite simple. Create Excel document on the server, delete transfer to the client, delete it on the server and then display it on the client.
Continue reading “Excel SaveAs via COM/OLE – Automation fails under W2008”
I read and hear more and more about Sublime Text. And although the editor’s beta version 3 has been around for ages, I’ve been working on Sublime Text 2. Well, what can I say? It’s a fantastic editor. There are a lot of different functions and plugins here, which make it easier to work with and almost exclude the use of the mouse.
I looked at the W. P. Hill Tech article. Here the author describes how to use ST2 as a build system for PL/SQL.