HTML Region - Apex JavaScript?

Sep 12, 2010

I have a html region with the following

<html>
<head>
<title>Report</title>
</head>
<script language="JavaScript1.2">
function items()

[code]...

I have a text box item "BINDTEST" that has html element set to:onchange="items();"

I have a button with a url redirect of:

javascriptopon[URL}...

When I click on the button, popup window opens with test url but bindtest1 variable is not appended. What is proper form for trying to get value of bind variable in the url.

View 3 Replies


ADVERTISEMENT

Application Express :: Turned Out By Disabling Javascript Whole Login Region Disappeared

Nov 8, 2012

Application Express 4.1.1.00.23
Internet Explorer - 8
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I am about to embark on my first APEX development and have got far as the login screen. I disabled JavaScript just to see what would happen if someone had it disable, it turned out by disabling javascript the whole login region dissapeared. I am wondering how to develop the application so it works when javascript is disabled. I am using the cloudy theme. Not sure how to develop the application as its got to work with JavaScript disabled.

View 11 Replies View Related

Application Express :: Updating APEX Collection Via JavaScript?

Aug 1, 2012

Note, I'm using APEX 4.1.1

The scenario is that I have tabular form that was manually created from a collection; the collection name is "COMPANY"

Within this tabular form, I have number of selection lists (apex_item.select_list) and for each, I fire off a JavaScript based on the "onchange" event (e.g.,'onchange="updateCollection(' || seq_id || ', 10, this.value)"'); updateCollection is a custom function I created. Right now, all it does is alert me with the specifics of the of the selection list. As a further example, if I select "Google" from the selection list, sequence id would be "1", attribute number would be "10" and attribute value would be "Google"

Within this JavaScript, I would like to update the value of this associated element in the "COMPANY" collection. Ideally, I would like to directly call this:

APEX_COLLECTION.UPDATE_MEMBER_ATTRIBUTE(p_collection_name => "COMPANY", p_seq => 1, p_attr_number => 10, p_attr_value => 'Google') but I could not figure out how to do this.

View 11 Replies View Related

Application Express :: HTML Text In Reports Sub-region Not Displaying

Nov 30, 2012

I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .

View 1 Replies View Related

Application Express :: Possible To Display Null Item Value As All In Blank HTML Region

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

Application Express :: How To Present A Report From BI Publisher To Inside HTML Region

Feb 12, 2013

how to present a report from BI publisher to inside a HTML region ?

View 1 Replies View Related

Application Express :: Display PDF In Apex Region?

Jul 11, 2012

I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.

I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned

[URL]...

View 20 Replies View Related

Application Express :: Image Stored In Table Is Not Showing In HTML Or Report Region

Aug 22, 2012

I am using apex 4.1 and database as oracle 11g. I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> (     "ID" NUMBER,
>>     "HR_ID" NUMBER NOT NULL ENABLE,
>>     "PHOTO_BLOB" BLOB,
>>     "MIME_TYPE" VARCHAR2(64),
>>     PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

[URL].......

[URL]........

But the image is not getting populated in the region, I tried with display_item with image i am able to view the image using this item.

View 19 Replies View Related

Application Express :: Color HTML Region Header Depending On SQL Query Result

Jul 24, 2013

How to color HTML region header depending on SQL query result ?

View 9 Replies View Related

Application Express :: Opening HTML Link From APEX Page

Nov 8, 2012

I have an apex page with a link on one column for each row. My requirement is as below

When i click on the first time on any of that link, it opens up in a new window and any subsequent clicks should override the previously opened window. So at a time, there should be only 2 windows open..

1) the APEX page
2) The browser window after clicking on an link in apex page

View 12 Replies View Related

Application Express :: Error When Refreshing Report Region / ORA-20876 - Stop APEX Engine

Mar 26, 2013

I'm using Apex 4.2. On click of a button, I refresh 2 Standard Region Reports with a Dynamic Action. This dynamic action has been working without problems for WEEKS and all of a sudden i'm getting the ORA-20876: Stop APEX Engine error when I click the button.

In the dynamic action, I removed the refresh of the second report and now the error does not occur. If I add the second refresh action back in, it throws the above error. I've even tried making the second report identical to the first and the refresh action fails. why this is failing on the second refresh action since the second report & region is IDENTICAL to the first report now.

View 3 Replies View Related

Application Express Listener :: APEX Listener With APEX 3.0 On 11gR2?

Jun 29, 2012

We have many many APEX applications in APEX 3.0 running on a 10.2.0.4 database that needs desperately to be upgraded. As a test, I've set up a clean 11gR2 database and copied the production APEX database into it via datapump. I set up APEX Listener, as I don't have any OAS sitting around and the EPG doesn't seem to be supported for APEX 3.0... the Listener doesn't say one way or the other.

When trying to log in, I get the login page, but it tries to reference files such as apex_get_3_1.js while I only have files such as htmldb_get.js in my images directory in production. I noticed it is looking for what appears to be 3.1 files instead of 3.0 files... which concerns me.

The APEX listener appears to be more than just a Java PL/SQL gateway.

Is there a minimum version of APEX the APEX Listener supports?

View 2 Replies View Related

Calling PL/SQL Procedure From JavaScript?

Oct 8, 2007

The application I am working on uses Oracle HTP procedures to generate HTML pages for our application. I am trying to perform some cleanup when a user closes a web application by clicking the 'X' button in there browser. I am thinking of using the onUnload trigger to call a javascript function, which in turn would call a procedure in my PL/SQL pacakge for cleaning up logical locks on records.

The body tag delaration looks like this code fragment:

htp.print('<BODY onUnload="clear_locks(' || p_user_id || ')"

Here is some psuedo code for the function i would like to use:

<SCRIPT>function clear_locks(p_user_id){
call clear_locks(p_user_id);
return true;
}</SCRIPT>

Note that clear_locks is a pl/sql stored procedure.So far I have gotten it to pass in the user ID correctly.Is there a way I can call my clear_locks procedure?

View 1 Replies View Related

Application Express :: Set Popup LOV Value From JavaScript?

Sep 3, 2013

I use APEX 4.2.2 and in my page I call a Modal Region to insert a new customer using AIAX and OnDemand PL/SQL process, then I need to set the inserted value into the Popup LOV from javascript. I used the code

:$('dialog').dialog('close');$('P20_CUSTOMER').trigger('apexrefresh');$('P20_CUSTOMER').one('apexafterrefresh', function()  { apex.item('P20_CUSTOMER').setValue(ajaxResult, $v('P20_DESCRIPTION'));} 

where P20_CUSTOMER is the Popup LOV, ajaxResult is the PK returning from the OnDemand PL/SQL process and P20_DESCRIPTION is an APEX Item of the Modal Region. The new customer is inserted successfully into the table and the PK value returned to javascript code, but the new value is not displayed into the LOV.

View 1 Replies View Related

Application Express :: Display Only And JavaScript

Oct 26, 2012

I have two Select Lists P58_TYPE_DOC (it shows for users that have not adm profile) and P58_TYPE_DOC_ADM (it shows just for administrator).

On my Page proprieties I have on HTML Header this code :

onload="show_fk_facture('P58_TYPE_DOC');show_fk_facture('P58_TYPE_DOC_ADM');"

I have to execute the java script when the page loads, but I cant execute the function for both items in the same time.

Because one of the items will be hidden, and the java script won't be able to find it.

I tried to use "if isNAN('P58_TYPE_DOC') else ....." but it doesnt work.

View 11 Replies View Related

Application Express :: Set Variable Via Javascript

May 16, 2013

I got a long string (length exceeds 32512) from Javascript, and want to pass the sting to a variable to a item called P_SQL

I use *$x("P_SQL").value* in javascript to set the value, but my process couldn't get the value before I submit, however, when I do submit it reports an error like this : Bad Request

Your browser sent a request that this server could not understand.mod_plsql: /pls/alq/wwv_flow.accept HTTP-400 Value param too long. Length is 216343. Upper limit is 32512

how to handle this conflict ?

View 4 Replies View Related

SQL & PL/SQL :: JavaScript And Oracle DB Updating A Table Item?

Feb 19, 2010

I want to use java-script to open a prompt to see if the user wants to change the date of a work order (Located in Work_order_info called "opened_date")

What I have so far:

var n = prompt("Is the checklist starting now? (Type either y or n)", "y or n");
if (n == "y" || n == "Y"){
alert("The opened date has now been changed!");
}else if (n = "n" || n == "N"){
alert("The opened date has not been changed!");
}else{
alert("You needed to type either n or y, nothing else!");
}

I'm not entirely sure how to tell the table to change the opened_date to sysdate. I'm sure it's really simple >.

View 2 Replies View Related

Application Express :: JavaScript Code In Page Zero?

Sep 27, 2012

I have javascript code i want to move from standard report page to page zero, well page 0 doesn't have html header/page attribute section so how to i achieve this?

View 7 Replies View Related

Application Express :: Use Javascript.addrow() In A New Page?

Oct 5, 2012

In a normal tabular form, with the add, delete, submit option, Under the add button we have the javascript.addrow() call which creates a new row. However, in my case the rows in the tabular form have some columns as display type. So when the user clicks on the add button, he cannot enter all the fields. Is there a way

1. Either to enable all columns of a new row only so that users can add all values and save

2. Or atleast open a new page where the new row is open with all editable fields?

Version:4.1.0
11g

View 1 Replies View Related

Application Express :: Setting MaxDate Using Javascript?

Jun 24, 2013

I am struggling to set the maxDate of a datetimepicker.

In the document load of the page I have this:

$('#P64_STARTDT').datepicker("option", "maxDate", $v('P64_XFORMATSTARTDT'));

P64_XFORMATSTARTDT is in the format YYYYMMDDHH24MI

It never sets it.

View 3 Replies View Related

Application Express :: Difference Between JavaScript And Checkbox

Nov 18, 2013

How to check off checkbox with JavaScript. I tried

1) $("#checkboxID").prop('checked' , false) (jQuery)
2)    $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1

Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.

View 3 Replies View Related

Application Express :: Changing Color Using JavaScript In IE8

Nov 19, 2013

Apex version 4.1.1.00.23IE8 (8.0.7601.17514)Firefox 25.0 

 I have a tabbed form that I need to conditionally disable rows (making them read only). I'm using Javascript to set the attributes of the fields that need to be set.A request was  made to make the font color of the read only fields black so that they're easier to read.I'm not able to get the font changed to black on the fields that are Select Lists in Internet Explorer. They are staying gray, however, they are set to black in Firefox. The JavaScript code for one of the Select List is:   

var curr_id = html_GetElement('f42').id; //Group
$x(curr_id).disabled = true;
$x(curr_id).style.background = "silver";
//$x(curr_id).style.color = "black";
$x(curr_id).style.color = "#000000"; //black

View 7 Replies View Related

Application Express :: Passing Variable To Javascript

Aug 28, 2013

4.1.2theme 24

I have a .js process in the before header of a page which has this pl/sql process using htp script javascript function {code} 

function check(flag_val){ if(flag_val=="N") 
document.getElementById("btn").disabled = true;
else 
document.getElementById("btn").disabled = false;  } 
{code} 

and then there is the actual pl/sql process which  has a cursor 

{code} 
declareflg varchar2(1);
..begin selectflag into v_flagfrom table where rownum = 1;
-- actual conditions are different but this returns one value.

 Then below using htp package I had html table with something like 

<td align="right">
<button class="btn btn-success" type="button" id="btn"  onclick="check(flg);"
title="Accept Lead" style=" width:50px;">Flag value</button> </td>  
 {code}

For some reason the script function is not called if I use onload. If I change the onload to onclick it works. Also, if I pass check(flg) it does not work. If I use check(''N'') then is works fine. question is how do I pass a pl/sql variable flg in this case to a javascript function as a parameter? I basically, want the value of flg checked on page load and then if it is N then disable the button. Or else keep it enabled.

View 0 Replies View Related

Application Express :: Additional JavaScript For Websheet?

Oct 11, 2013

I need some functionality in current (4.2.2) APEX websheet which seems not possible out of the box.Therefore I'd like to ad a javascript to my websheet application.

View 0 Replies View Related

Application Express :: Passing Item Values To Javascript

Nov 23, 2012

APEX 4.2 - Base code from Denes examples

CODE ON HTML HEADER

<script language="JavaScript" type="text/javascript">
function f_setglp(pThis,p_app_item,p_other_record_level_item)
{    
var curr_id = $x(pThis).id; // OK !
var curr_glp = $x(p_app_item).id; // returns undefined
var curr_orli = $x(p_other_record_level_item).id; // returns undefined

[Code]...

The Javasxcript function fires OK on click in the "Product" attribute but: PMO_GLP_PK is an Application Item that Javascript can´t reference as I called YES_NO is another tabular form attribute and the reference returns also "undefined"

what is the best way to implement this ?

View 4 Replies View Related

Application Express :: Javascript Function For Tabular Form Changes?

Apr 12, 2013

I have a tabular form with a few columns. THey are ID, date1, date2 and task_name. The task_name is a drop down list of tasks. Upon selecting a specific task, I want the date1 and/or date2 columns to become read only (voided out) so users cannot enter in data. I am working with a tabular form, so I figured I need a javascript function to handle the logic and to call the function in the html elements of the column in the apex environment. This will need to happen dynamically (on click) before the page is submitted. I am more lost/confused on syntax. I know I will need to know the actual column name (coo1, coo2, something like that) of my columns that I will be refering to when I use javascript.

View 2 Replies View Related

Application Express :: JavaScript API To Set Item Values Not Working In 4.2 EA2?

Aug 7, 2012

I had a complex drill-down dashboard where I was setting page items through $s(Page Item, value) from the Chart Links. But when I did the same thing in APEX 4.2 EA on [URL]...it is simply opening a blank page. whether in 4.2 that Java API has been removed?

View 4 Replies View Related

JDeveloper, Java & XML :: Accomplish Animation With JavaScript Or Will Have To Turn Into Flash?

Dec 30, 2010

Can i accomplish animation with JavaScript or will i have to turn into Flash?

View -1 Replies View Related

JDeveloper, Java & XML :: Kill Oracle Database Session From Javascript

Feb 24, 2013

how could we kill oracle database session from javascript/java application.

View 2 Replies View Related

Application Express :: Error In Javascript Not Fetching Value On Button Click

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







Copyrights 2005-15 www.BigResource.com, All rights reserved