Application Express Listener :: When Click On Add File It Display A Blank Page?
Nov 10, 2012
My configuration is
APEX 4.2 on Windows XP with APEX Listnere on Glassfish 3.1.2 Open Source Server Edition.
The database is 11G XE
Let me explain the scenario which is not working.A Modal region which is having a file browse item based on WWV_FLOW_FILES and a button called add file.
When I click on add file it display a blank page and in the URL I could see [URL]...But actually it inserted file in the table.
I have put wwv_flow* in Listener Configuration for allowed procedures.I have another page where I have a page item which is based on BLOB column specified in item source attribute. And that is inserting file and displaying the pages correctly.
View 0 Replies
ADVERTISEMENT
Jan 15, 2013
Problem is that page is blank and freezed. After another enter in URL page is shown normally.What I find out is that "freeze" happened only in Apex design time ... never in runtime of any of mine app.
Mine conf:
Apex 4.2.1 on
Apex Listener standalone 2.0.0.354.17.06
Oracle 11.2.03 x64
Windows 2008 SE R2 x64
C:UsersDamirV>java -version
java version "1.6.0_34"
Java(TM) SE Runtime Environment (build 1.6.0_34-b04)
Java HotSpot(TM) 64-Bit Server VM (build 20.9-b04, mixed mode)error log:
D:UsersdamirvDesktopApexApex-Misc>set ORACLE_HOME=c:oracleproduct11.2.0dbhome_1
[code].....
View 4 Replies
View Related
Oct 24, 2012
I installed APEX 4.2 over XE 11.2
The Installation process succeeded.I Used the Installation Guide -> and followed the steps from chapter 3...My problem after the Apex-Upgrade ->
The page URL.... is blank, or say it better, ... there is nothing visible on that page (no Login-Form)The original GetStarted page from XE Database -> URL.... shows an Error Error Error processing request.ORA-01403: no data found
I can post the sourcecode from the "blank" HTML-Page...
View 20 Replies
View Related
Jun 27, 2012
I have a report that contains a name that I want to pass in to a field in a form on a different region on the same page. My button located on the report is has its own column called ADD_LINK. Here is the button.
<button id="apexir_btn_ADD" class="apexir-button" type="button" value="Add" onclick=""><span>Add</span></button>
Once that button is clicked, I have the form region fade in. The region is called Add Tag to Employee, which has P4_ROWID, P4_EMPLOYEE_ID, and P4_TAG_ID. Once the region is displayed, I want the #NAME# to show in the P4_EMPLOYEE_ID.
I did copy this form from another page, where I had it working before. It made more sense to move it to this page for interface purposes, so maybe that tidbit will work as well.
View 15 Replies
View Related
Jul 2, 2012
Apex 4.1
Theme 21
I have select list which has null and other values. I have created a blank HTML region with the following text
Report for the year &P2_YEAR. and for geography &P2_GEOG.
Now P2_YEAR works fine because, it is always populated with a year. However, &P2_GEOG has 'All' as null value since we can see the report for all geographies. However, if the all option is selected, the above &P2_GEOG. shows as null. Since its not a PL/SQL proc, I cannot put in a NVL. I am guessing one possible way is to write a PL/SQL code before region and then check if its null and then try to populate a new hidden field and show, something like that. Wondering if there is a way to do it directly in the HTML region?
View 0 Replies
View Related
Jul 30, 2013
My configuration is GlassFish 4 (the same thing with Glass Fish 3.2) + win7 + Apex Listener 2.2 (the same thing with Apex Listener 2.1) + Apex 4.2.2 I get blank page when trying to connect to APEX. But after loggin into GlassFish admin page (exactly login with username+password; just open admin page is not enough) in another browser tab I get proper Apex page with all images.
View 1 Replies
View Related
Mar 23, 2013
i want to display a list of all users on a page those currently accessing or using the application. How do i accomplish this requirement?
View 1 Replies
View Related
Sep 24, 2012
APEX 4.0 Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
I have a table which contain 3 columns, see below:
id primary key
pic1 blob
pic2 blog
there is 1 row in it(id=1), just for display 2 images.
Uploaded 2 images into above Blob fields by file browse function. Now, I want to show the 2 pictures in a Region by using display image item P1_AR, but it didn't work.
Based on: BLOB Columns specified in item source
Alternative Text Column: null
Filename Column: null
BLOB last update Column: nullSource used: Only when current value in session state is null
Source type: SQL Query(return single value)
Source value or express: select dbms_lob.getlength(PIC) from cp_pic where id=1
I got the error below after runing:
ORA-20999: P1_AR has to have a valid BLOB column as source
View 7 Replies
View Related
Sep 5, 2013
I have a page with two regions the top region is an html region where users enter query criteria and generate an interactive report in the second region. The second region only displays if there are results from the query in the first region.
I would like to display a "No Results Found" message rather than a blank screen if there are no results found. However, I don't know exactly how to do that. I tried to do it in the Interactive Report region, however, once I added the Conditional display to only when exists rows in the Interactive Report from the query criteria.
View 4 Replies
View Related
Feb 22, 2013
I have the following problem.
By clicking on a button on my page, I execute a Dynamic Action. That Dynamic Action consists of several True Actions, one of which is Execute PL/SQL code where I execute a procedure. I'm doing this without submitting the page, and that works fine.
However, I would like to display an error message on the top of the page, in case my procedure returns an error, and I would like to do that without submitting the page.
Is this possible?
View 6 Replies
View Related
Jul 6, 2012
How to use process to display the date parameters selected by the user to generate the report in Page title ?
View 2 Replies
View Related
Sep 7, 2012
I would like to have a table in HTML region and to display in the table some Page Items from the page.
I got the code like this:
{
<table>
<tr><td>&P1_ECEMEA_ASSISTANCE</td></tr>
<tr><td>&P1_ECEMEA_WIP</td></tr>
</table>
}
It shows the Page Item names as text, not the values. However this code without the table tags:
{
ECEMEA Request for CQT Assistance: &P1_ECEMEA_ASSISTANCE.
ECEMEA CQT Work in Progress: &P1_ECEMEA_WIP.
}
works and the Page Item values are displayed.
Is it possible to display the Page Item values in the HTML table at all or I have to use a different method of showing the values in a table? The above is only a snippet of the code. I need to display about 30 Page Items, formatted in a table with headings.
what kind of region is the best to be used or if I should only use some escape symbols in the table code.
View 2 Replies
View Related
Sep 28, 2012
I get an ERR-7621 from Apex whenever I do anything in an application the tries to read a file. For example importing images, css files, themes, or applications. Even the data loader app will get the error if you choose to load a "csv" file. The following appears in my Apex Listener Log (version 2 early adopter). I am running 4.1.1 of Apex and also have another server running the same where the problem does not exist. Following is the log output whenever the load occurs:
Sep 28, 2012 11:21:18 AM com.sun.grizzly.http.servlet.ServletAdapter doService
SEVERE: service exception:
java.lang.NumberFormatException: For input string: ""
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
[Code].....
View 1 Replies
View Related
Feb 4, 2013
I want to upload file using restful service This is my code to send file to rest service
MultipartEntity reqEntity = new MultipartEntity(HttpMultipartMode.BROWSER_COMPATIBLE);
FileBody bin = new FileBody(f);
FormBodyPart bodypart = new FormBodyPart("file", bin);
reqEntity.addPart(bodypart);
[code]...
But how can i retrive at server side in restful service using plsql?
View 0 Replies
View Related
May 21, 2013
How can I access this "file:///C:/Users/RI/m_1.html" external file within the apex page?
I created a page and button for link but struggling for above.
View 5 Replies
View Related
Jun 10, 2011
I am trying to investigate my execution plans against my DB; and was informed i can check current status of SQL scripts using:
Performance tab > SQL Monitoring > Monitored SQL Executions
I click on SQL ID i want to investigate and comes back with blank screen instead of the overview tab.
See Oracle URL below for screenshot
Figure 6-8 Monitored SQL Execution Details Page
[URL]
View 2 Replies
View Related
Feb 15, 2013
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
View 0 Replies
View Related
Jan 15, 2013
I am working in apex 4.2.1.
I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.
So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.
<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......
View 6 Replies
View Related
Oct 4, 2013
i have a table say 'temp' with 4 columns as seq, name, event, id and i have a pg with 3 text fields as name, event, id now ma issue is,if i enter values into those 3 text fields in that page and on a button click (say create), i wanted dose values to get inserted into 'temp' table andregarding , 'seq' column i hav created a sequence for it. so
1. how to insert values into the table by entering values in the page
2. wat shd b done for seq column.. (shd anyth b done from apex pages or wil it automatically get values for each row entered)
View 4 Replies
View Related
Sep 17, 2013
My application build in Apex 4.1, Oracle 11gr2In my application, there are three pages:
Page1 (Dashboard): contains 6 different chart
page60: Generate a chart based on a value passed from page1
Page14: Generate a report based on a the value passed from Page1 and Page60
I want to pass value "3" to page item P60_KPI_NO and P14_KPI_NO when click on first chart I want to pass value "4" to page item P60_KPI_NO and P14_KPI_NO when click on second chart.
View 0 Replies
View Related
Nov 13, 2012
i have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
View 3 Replies
View Related
Jun 4, 2013
We are using Application Express 4.1.0.00.32 on Wondows XP and Oracle version is 10g. I've created a report in APEX and the user is insisting on putting a header on each page in PRINT of the report which should contain the "from date" and "to date", which are present on the select criteria on top.
Can I somehow add from_date and to_date items in Title so that when they print the report, they'll see the from and to dates in the title?Or is there someother way to do this. The report is an interactive report with a control break and user prints the report with file->print.
View 1 Replies
View Related
May 21, 2013
In the login page, I want to add a text "Register" that when clicked will send the user to another page to register.
With a button, its simple because its inbuilt there,but I do not want a button,just this: Register
I want also to have the text in color not black.
View 6 Replies
View Related
Jul 16, 2013
I am new to APEX and I am developing an application to manage Oracle database user accounts. I have a page (8) that has text items for the username and the database name. I have a submit button (this works fine) that will issue the ALTER USER... statement to reset the user's password and unlock the account. I have another button that should:
get the value of the username - P8_USERNAMEassign it to an application item - FIND_USER_IN_DBredirect to page in application - to page 11
The issue is that FIND_USER_IN_DB does not get populated and page 11
which is a simple report with the following query:
SELECT *FROM valid_dbWHERE username = :FIND_USER_IN_DB;
How do I accomplish this?
View 8 Replies
View Related
Aug 17, 2012
I have different public page (page1) and different page for authorized user(page5).Upon successful login after process validation ,computation it should navigate to authorized user page 5 but the branching does work it keeps on going to page 1 .
View 8 Replies
View Related
Nov 23, 2012
I am using APEX 4.1 to build the application. I have 2 select list region in the page where one region consist of certain values.On calling a javascript function it is able to move the value from one select region to another. After this I click on the modify button where in the value move out of the first select list region to the second will be updated in the table.
Although I could see the values are not being updates. On putting alerts after the value being fetched in the javascript function and clicking the Modify button I can see that no data is being reflected in the alert. Hence the data is not being passed from the second select list APEX item to the javascript function.
View 1 Replies
View Related
Jun 29, 2013
I have a requirement wherein onclick of button I want to open/close list/popup (which is displayed below button, just like in select list) and can select any item from list to do some action.
View 7 Replies
View Related
Jun 19, 2013
Apex 4.2.0.00.27 I have a page with a Form region and a Classic Report region. How can I automatically save changes made in the Form when a user clicks the Edit link column in the Report? At the moment, when the user returns to the Form, any changes made there are lost.
View 2 Replies
View Related
Jul 8, 2009
I have developed a form which has webutil objects in it, and it is working fine on my local machine. When I deploy my form to my application server it opens up a blank page. I have configured the webutils in the app server as per the document and made entries into formsweb.cfg regarding frmwebutil.jar,jacob.jar. Does the dev suite need to be installed in the server for the webutils to run properly?
Also I watched my java console as I opened my form and I am pasting the contents below:
-----------------
Loading frmwebutil.jar from JAR cache
Loading jacob.jar from JAR cache
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
Forms Applet version is : 10.1.2.3
[code]...
View 14 Replies
View Related
Aug 23, 2012
Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
View 0 Replies
View Related
