Yesterday an interesting question regarding tabular forms, collections and instant updates was asked in the
Oracle APEX Forum. This
example in my
Demo Application shows how you can create a tabular form based on a collection and update this collection instantly. The whole example consists of three main parts:
1.
(more...)
I know this is nothing new but I had a hard time to find this out. In one of my projects I needed the exact query of an interactive report in order to save the data into a PL/SQL collection. I tried using the provided IR Application Views but those
(more...)
Since APEX 4.0 cascading feature is a part of the standard. Not only a "normal" select list can be cascading but also a shuttle element. In
this example I am showing how to filter a shuttle box and move the filtered values to the right side using just one
(more...)
There is a new plugin available which makes it possible to save and render contents larger than 32k. This limitation was one of the most critical in APEX. I remember several projects where we had to create workarrounds to solve that issue. Now, there is no need to write your
(more...)
It seem that there is a bug in APEX regarding deep linking, authentication and parsing special characters. See this
thread. In
this example I am showing a simple workarround which could be also applied in other similar situations where you need to transfer information using URL.
I still remember how hard it was to make something like this working before the APEX version 4.0. You needed to create a function and then attach it to each column in your tabular form. Debugging and making changes is the next issue you had to think about. Now,
(more...)
If you need to create a dynamic SQL for a select list or any other type of a LOV, your query should not exceed 4000 characters. In case it does, you will get the "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" error. That is the internal
(more...)
Sometimes you need to format a report column and if you need to do that in the report SQL, you will be faced with a problem while exporting the report - the formatted values will be exported 1:1 and you will see those ugly html tags among the exported data.
(more...)
APEX Collections is one of the best features of APEX. There are situations where solutions wouldn't be possible if this feature would not be available. However, the collections have some limitations. One of the limitations is if you need to store number values and use those values to join a
(more...)
Today one of my customers upgraded their APEX 4.0 to 4.2.1.00.08. The whole process was completed without any issues. After the upgrade there was only one problem we could notice. Our translated applications didn't work for the other languages then the primary language. Trying to
(more...)
In
this example at
apex.oracle.com you can se how you can use an URL (which normaly provides a save/download dialog for saving or opening a document) to store the document directly in your own table as a BLOB. Unfortunatelly the ACL settings at apex.oracle.com do not
(more...)
This is the text of an email I received as a response after creating an account for my workspace and
my demo application at
apex.oracle.com:
"Thank you so much. Oracle and APEX has the most amazing network of help and solutions. It is impressive."
Wie jedes Jahr in den letzten sechs Jahren, veranstalten wir (
Dietmar Aust und ich) unser
Training in Bensheim an der Bergstrasse. Wir werden unsere bisherigen Themen überarbeiten und einige neue Themen hinzufügen. So werde ich auch folgende neue Themen in das Programm
(more...)
If you write a lot of PL/SQL code, sooner or later you will be faced with a requirement to count the number of occurrences of a substring in a string. In that case you may use this example to help yourself:
http://apex.oracle.com/pls/apex/f?p=31517:282It will search not only
(more...)
It is now official - my friend
Dietmar Aust is an Oracle ACE.
Congratulations. Well deserved.
Sometimes you will need to create your own processes for fetching values, validating and updating tables in a form. In some situations the wizard generated form will not be good enough to cover all you need. In that case you need to write your own code. Some programs like TOAD
(more...)
http://www.apexblogs.info was a place I visited daily. A couple of days ago this domain was moved to
http://www.odtug.com/apex. I am not sure I understand why but it doesn't matter. The only thing is that from the usability perspective this is now at least two steps back.
(more...)
This function may help you if you need to report on columns with a lot of text. It will get rid of the carriage return and will help not to break your reports imported into Excel:
CREATE OR REPLACE FUNCTION x_rep (p_string IN VARCHAR2)
RETURN VARCHAR2
IS
v_string VARCHAR2 (4000);
(more...)
RSS