Within ApEx PL/SQL Processes, regions and items you can use the bind variable syntax (
:PX_MY_ITEM) both to read and set the value of that item held in session state. Like so:
:PX_MY_ITEM := 'wibble';
l_my_local_variable := :PX_MY_ITEM;
However, in stored PL/SQL packages, procedures and functions you cannot use the bind variable syntax. Rather, you must use the
v('PX_MY_ITEM') syntax. But this is read only.
So how do you set the value held in session state for a given page item from within a stored package, procedure or function?
The answer lies in the
set_session_state procedure found in the
APEX_UTIL package. E.g.
p_name => 'PX_MY_ITEM'
, p_value => 'wibble');
Thanks to Andrew Tulley
Oracle has released the Early Adopter and welcoming the feedback. Lot of new features and mobile enhancements are available, please check the following link.
Apex 4.2 Early Adopter Features
Keep it up and move forward.
Thanks to Patrick Wolf
One of the new features of Apex 4 are Cascading LOVs/Select Lists. I’m pretty sure that almost every APEX developer had already the requirement to refresh a child select list when a parent select list was changed. For example you pick a department in the first select list and the second should just show employees of that department. There are two solutions to solve that:
- Use a “Select List with Submit” for the department field, which will automatically submit and refresh the page when a department is picked. In the Web 2.0 world that’s a little bit outdated and it can also takes quite long to refresh the full page. You also have to take care that your validations and processes do not fire in that specific case. So quite a number of extra conditions are necessary to deal with the auto submit. This solution doesn’t really make the page more maintainable and the user experience is also not very great.
So both solutions are not really satisfying because the require quite a bit of coding, which makes the application harder to maintain. But with Oracle Application Express 4.0 there is now a third solution for the problem. It gives the user a great UI experience and doesn’t require any additional coding!
Declarative “Cascading LOV” support for all “List of Values” based item types! That means select list, checkbox, radio group and shuttle based page items can automatically be refreshed if a parent field gets changed. (Note: Popup LOV and List Manager will be added as well in the final product) Important to mention here is that the parent field doesn’t have to be a select list, it can be a simple text field, date picker, … as well. Every DOM element which fires a change event will work as parent.
To add “Cascading LOV” support for a child page item, you just have to set the new“Cascading LOV Parent Item(s)” attribute in the “List of Values” section to the name of your parent page item. That’s it! This will tell APEX to automatically refresh the page item with new values each time the parent item gets changed.
So let’s create a simple example where we first select a department and then an employee in that department.
- Create page item P2_DEPTNO of type “Select List” with the following LOV statement
order by 1
- Create page item P2_EMPNO of type “Select List” with the following settings
That’s all! Super simple as it should be.
If you have a look at the screenshot above you will see that Cascading LOVs have the attributes “Page Items to Submit” and “Optimize Refresh” as well. Most time you will probably not need to set them. For details about them consult the page item level help.
Dear All, please find the below link, it is very useful information who does not have their own SMTP.
Before deploying latest apex images in web logic server, you must create a Web archive (WAR) file to contain the Oracle APEX image files.
Using the Java Archive (jar) command, enter the following command to create a Web archive file named images.war:
jar –cvf0 <temp directory>images.war –C <apex directory>images .
■ <temp directory> is the directory location of the unzipped Oracle Application
Express Listener file.
■ <apex directory> is the directory location of Oracle Application Express.
Thanks to Oracle
வியாபாரத்தில் அதிக லாபம் பார்க்க கூடாது ஆணால் மத்திய அரசும், மாநில அரசும் கூட்டுக்கொள்ளையாக பெட்ரோல் விலையை 50% மேலாக அதிக விலைவைத்து மக்களிடம் விற்கிறது – இது நியாயமா? இது தர்மமா?
சாராயம் விற்கும் தமிழக அரசே, மக்களை நல்வழி படுத்துவது எப்போது?
Thanks to Vikatan.com