How to implement web services in Oracle Apex Now a days we face frequently such a requirement of retrieving data from external application or Website on demand and displaying it in the oracle apex page. I have done same requirement in one of my application recently and wanted to share …
How to upgrade Oracle Apex 5.1 to 18.1 Please do the following steps: I assume you have already installed Apex 5.1 in the Apache Tomcat environment In this up gradation steps you only need to fresh install of Oracle Apex. It does not require to Re-install/Re-configure of REST data service, …
Sometimes the ORACLE REST DATA SERVICES shows some of the below unexpected and annoying errors which prevents to launch Oracle Apex Instances: 404 Not found REST data service not available The request could not be mapped to any database….. and so on I found the below solution and you can …
Create a PL/SQL Process PL/SQL Code
|
1 2 |
APEX_UTIL.SET_SESSION_TIME_ZONE ( P_TIME_ZONE => :P1_SET_TIME_ZONE); |
Thank You
Create a Dynamic Action Named “Refresh Report” Event = Dialog Closed Selection Type = JavaScript Expression Client-Side Condition > JavaScript Expression
|
1 |
window |
Add a True Action Action = Refresh Selection Type = Region Region = Employee List (set your own region here) Apply Changes and run the page. you will …
Create a Dynamic Action Create a True Action Action = Execute JavaScript Code Code =
|
1 |
apex.message.showPageSuccess('Action Processed.'); |
Thank You
Create 2 Text Items P1_SCREEN_WIDTH P1_SCREEN_HEIGHT 2. Create a Dynamic Action Named “get Screen Resolution” Event = Page Load True Action = Set Value Set Type = JavaScript Expression JavaScript Expression =
|
1 |
window.screen.availWidth |
Affected Elements > Selection Type : Item(s) Item(s): P1_SCREEN_WIDTH Fire on Initialization :Yes Create another True action under …
Go to the Item Property Advanced > Custom Attributes Type the below Code:
|
1 |
style="text-transform:uppercase" |
for Lower Case:
|
1 |
style="text-transform:lowercase" |
when you save and run the page, you will see what ever the user types, inline it will be auto converted to upper case. Thank You
Go to the item property Advanced > Custom Attributes Type the below code:
|
1 |
onmouseover="toolTip_enable(event,this,'Employee Name')" ; |
When you put mouse on “Employee Name” text field ( as example) it will show the tool tip ‘Employee Name’ Thank You
Create a Page Process as shown below: Name: Redirect Page Source PL/SQL Code:
|
1 2 3 4 5 6 7 |
DECLARE v_redirect_url VARCHAR2(100) := 'f?p=102:101'; BEGIN htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; |
Execution Options > Point > Before Header Sequence : 1 When this page will be called, automatically before loading this calling page, it will be redirect to the page 101. you can set your own destination …
