Oracle How to get variable from URL into Region header

I would like to know if its possible to pass variables into an url and to get them by javascript into the Region header.For example, I have the url: http://my_server:7777/pls/htmldb/f?p=102:1:::NO::P1_LOGIN,P1_TABLE:toto,correspwhere P1_LOGIN=toto and P1_TABLE=corresp and I want to get the value of ...

Oracle Bug: Flash charts and "Region Header" property

it looks like that the a Flash Chart region doesn't renders the text of the "Region Header" property in the header of the region, instead it is rendered in the footer of the region.See http://apex.oracle.com/pls/otn/f?p=2672:1 for an example.For SVG Charts it works.Patrick Check out my APEX-blog: ht ...

Oracle Page/Region Header and Footer internal storage locations

We are running APEX 3.1.2 in our environment.I have an application where we have put text information in the headers and footers of all regions and pages. The information in each header and footer is the same for each page, and region markings are the same as well.I input the text (wrapped in html t ...

Oracle Specifying a Region Header and Footer

May I ask you guys about 'Specifying a Region Header and Footer' on Region Definition?I have tried to use the #TIMING# and #ROWS_FETCHED# strings on a region and set the parameters on the region header as follows:-===Row(s) #FIRST_ROW_NUMBER# through #LAST_ROW_NUMBER# of #ROWS_FETCHED# displayed===H ...

Oracle Show SQL in region header/footer

For some complex query regions of type "PL/SQL function returning query", is there a way to display the actual query being executed (with all bind variables substituted) in the HTML source of the page? In other words, is there a way to put it in HTML comments in the region header or footer? ...

Oracle Display hidden field in region header?

I have a region that uses a SQL Query to generate report output. I have created a hidden field in the region called P10_TEMPIP, using the Source Value or Expression area I use :P10_TEMPIP := owa_util.get_cgi_env('REMOTE_ADDR') to assign it a value. I am trying to display the hidden field in the regi ...

Oracle Bug report: Search Region Header and Footer

When I click navigate toWorkspace XXX>Builder - Application XXX>Application Reports>Search Region Header and FooterI get areport error:ORA-06502: PL/SQL: numeric or value error: character string buffer too small ...

Oracle sysdate in region header

How do I set the sysdate in a region header or footer?I tried creating a global variable which is filled ON_NEW_INSTANCE but I am not sure how to access it in the header or footer.....The idea is to put something like:'Messages changed between #TWOWEEKSAGO# and #NOW#' in the header. ...

Oracle regarding region header and footer

HiIam new to this oracle application express and in the process of learning it. I want to know about the region header and footer attributes and for these attributes can be used and i found that some java script can be placed in region and footers though html header and body are present in the page. ...

Oracle Region Header and Footer

I am using "Region Templete without buttons and Titiles".in this, i have lot of empty space on top and bottom of the region.looks like this is because of header and footer's heights....how can i set region header and footer height (equal to 0) ...

Oracle put DATE into interactive report region header

I am using an interactive report, I want to change the report region header to contain the text:Data Last Refreshed on: 09-AUG-2010where the date is populated via a SQL query against the database.QUESTION: How can I get the result of a query to appear in the region header of an interactive report?I ...

Oracle APEX IR - Column Header – Add Color or Image background Per Cell

I realize that I a can alter the Column Header Cell to some degree utilizing: .apexir_<columname>And I realize Oracle does not want to disclose documents to support developers in this area.Question I have a requirement to have a more dynamic IR Report Column Header utilizing APEX 3.2.The appli ...

Oracle APEX IR - Column Header – Add Color or Image background Per Cell

I realize that I a can alter the Column Header Cell to some degree utilizing: .apexir_<columname>And I realize Oracle does not want to disclose documents to support developers in this area.Question I have a requirement to have a more dynamic IR Report Column Header utilizing APEX 3.2.The appli ...

Oracle APEX 4.0 Page Layout like tabs, breadcrumbs, region header, gets truncated

Most of the themes including theme17 does not appear properly whenyou Interactive Report is horizontally long (say 30 columns or more).The Page's tab bar, breadcrumb bar, region title bar, etc. gets truncated, I guess after 1920px length (browser screen) based on thebody CSS max-width attribute.Even ...

Oracle Region Header Background Color different to the theme template

for my apex application i configured the theme Blue Gray - 13. I want that my application displays all region-, report headers on every page in a different color, for example "magenta".My CSS Code in the page header on page1: <style type="text/css"> .t13RegionHeader {background-color ...

Oracle Region Header and Footer HTML do not properly contain Subregion

This appears counterintuitive-- Intuitively it would seem that the HTML generated by a subregion, including its header and footer should be properly contained (nested) in the parent region's generated HTML, the boundaries of which are the Header and Footer HTML given.I want this to be true because o ...

Oracle colon and white space in region header

I am passing the region headers from one page to another rather than using static header names. for example:- Clicking EDIT against a particular DEPT on DEPT page passes something like "Employees in Department:10" to my EMP page, but on EMP page I just get "Employees in Department" and there is noth ...

Oracle How to have tabular presentation, like "Modify Region" in APEX tool?

In the new version of APEX, when you modify a report region, we have Tabs to navigate between set of data.This is a very interesting layout presentation and I would like to know if it is possible for me to use this kind of layout in my APEX application?Any tips? ...

Oracle How to refresh only relevant region on apex

I have a page on apex which includes 3 chart region.Only one region can take parameter from select list and after run button clicked,whole page is resubmitted.I need to refresh only relevant chart region not the whole page,because other two region does not need to be refreshed. ...

Oracle Printing PDF from Report Region - Header Details

I've searched around for a while but was unable to find an answer to my query.I have a simple report region, which i added a "Print" link to the bottom of - this brings up a formatted PDF version of the report which can be printed out, i'm just using the default PDF layout.When it comes to adding a ...

Oracle sorry-duplicate thread,since problem in forumby5.45pm pl/sql region in apex

From sqlworkshop,I have created a view likeCREATE OR REPLACE FORCE VIEW VW_SUB_CL_ADD1 AS (select a.siteid siteid,a.bpaadd_0 bpaadd_0,a.bpanum_0 bpanum_0, case when a.bpaaddlig_0 = '' then '-' else a.bpaaddlig_0 end address1, case when a.bpaaddlig_1 = '' then '-' else a.bpaaddlig_1 end address2, cas ...

Oracle pl/sql region in apex

From sqlworkshop,I have created a view likeCREATE OR REPLACE FORCE VIEW VW_SUB_CL_ADD1 AS (select a.siteid siteid,a.bpaadd_0 bpaadd_0,a.bpanum_0 bpanum_0, case when a.bpaaddlig_0 = '' then '-' else a.bpaaddlig_0 end address1, case when a.bpaaddlig_1 = '' then '-' else a.bpaaddlig_1 end address2, cas ...

Oracle Sliding Region in Apex - javascript

This is an example of Apex SQL Report in a Region with Slide Effect - made with javascript: http://tryapexnow.com/apex/f?p=12090:10Waiting for comments here.Edited by: Valentin Tabacaru on Apr 30, 2010 5:39 PM ...

Oracle Displaying report columns in region header

I have a report region, that always displays only one row. I'd like to display a few of the columns values just above the report.For example:If my report looks like that: First Name | Last Name | Favorite Color John | Smith | Red I'd like to see just above the table: "John - Red"How do I do that? ...

Oracle Add date/time to report region header

Folks,I am trying to do something I had thought I had done many moons ago. I have a page, with a report region. I want to add the date/time to the report region title. I had thought I built a page variable with the page name and then some html formatting to right align the date/time into one string. ...

Oracle Refreshing only certain Region in APEX.

I have a requirement like this. I want to refresh only certain region in the Page and not the full page.Detailed Requirement: I have 2 region in Parent window.I am entering a value in parent window in the First region. so the child window gets Populated.I am entering some values in child window. so ...

Oracle Overflow region(s) in IR. Is it possible ?

i have many IRs in my application and most of them are having too many columns to be displayed in one screen, 15-25 in most cases. Unfortunately, i haven't find a way/option to implement an overflow region for one record. Has anyone achieved something like this, avoiding records to look like a train ...

Oracle PLSQL Funciton in SELECT query for a region in APEX

Hello, I am developing a SQL report based on SELECT query that uses a plsql function.However the PLSQL Function returns a numeric value and , in addition to that, it also has one out parameter.How do I display this out paramete's value on APEX report? ...

Oracle Wrong position of the APEX IR dropdown menus

After I customized IR theme with my own css, the menus drop down at the wrong place in IE. However this works fine in Firefox.Can anyone help please? ...

Oracle HEADER AND FOOTER IN HTML REGION

I want to create a repeatable HTML Header (not an ApEx region Header) for a HTML region as described inhttp://www.html4newbies.com/header_footer_tip.phpI want to include the header at different points in my HTML regionIt says that you need to save the Header in an external file and then reference it ...

Oracle How to Reuse an Apex Region?

I'm trying to reuse a region on apex, but i don't know how to do it.What i'm trying to do is to use the very same region (a sql region) on different pages.Could any one gave some clues? ...

Oracle Apex region width question

Does anyone know how to change the width of a region in Apex? ...

Oracle IR column Header value not displayed entirely during filteration

I have a IR, when I click any column Header and it shows the list of values as a dropdown.some of them (which are larger) get cut off.. means the the entire content/value are not displayed within the dropdown. [width of dropdown is fixed and no of characters in the content/value is more..]how can we ...

Oracle How to capture javascript event - javascript:void(false) in IR

In the Interactive report when we click any columns header and select any value from the list for that column.. by default Oracle APEX executes/fires the following javascript function.javascript:void(false); How can I capture this event in Dynamic Action.basically, I want to create a Dynamic Action ...

Oracle Javascript Function f_Hide_On_Value_Item_Row not working on APEX 3.0

I included function f_Hide_On_Value_Item_Row from htmldb_remix.js in one of my pages and it was working just fine. I upgraded to APEX 3.0 and the function is not working. The script is in the same directory /i/javascript/, and I have other scripts in that directory that are working. Is there any rea ...

Oracle Firefox 3.0 or Apex problem ?

For some regions I've defined a horizontal scrollbar - in the Region Header I wrote:div style="" It worked fine with IE, Firefox 2.x and Apex 2.x and 3.x.But after upgrading my browser to Firefox 3.0 this scollbar had disappeared ! Not only in Firefox, but in IE too - this seems very strange to me.I ...

Oracle IR Filters / Materialized Views / CSV download question

Could using a materialized view in the sql select of an Interactive report cause the downloading to a CSV file to ignore the IR filters? I have Interactive Reports where IR filters are ignored when downloading a CSV file. The report region displays correctly (IR filters work ok),I have Interactive R ...

Oracle Region Title substitution string

hi, i am trying to use &TITLE. in a region header as was expecting to see the title of the region shown ? it does not (apex 3.2)however the template for the region has this and it works fine..can someone help ? ...

Oracle Problem rendering html in Apex 3.1

I recently upgraded an older 2.0 app to Apex 3.1. In the app, I have a few textarea with html editor fields so the user can customize page instructions. In 2.0, I was able to query the database and store the text in a hidden item, then reference the value of that item in an html region for the text ...

Oracle Apex and ExtJS Grid...

I have been trying to implement ExtJS into Apex also but i am getting an error which i couldnt find a way to sort it out.... Can somebody help me? Here is the error message i got;The container of an boundary-point of a range is being set to either a node of an invalid type or a node with an ancestor ...

Oracle ORA-01858 error from Apex Report on working/valid underlying query

After two days of searching these forums and AskTom, I think I need to post the following problem.I have what seems to be a valid view of some data created as follows (with an apology for the formatting - doesn't seem to be a way of using a fixed font here):CREATE OR REPLACE FORCE VIEW "PRICING_CAPA ...

Oracle APEX built-in XSL template

In APEX, we needed to generate PDF-reports using fonts with unicode glyphs, which are not supported by FOP which is shipped with APEX, so I decided to configure our environment to use FOP 1.0. I've managed to get custom reports with APEX, however built-in XSL template (which is used to generate PDF- ...

Oracle Hide/Show Dynamic Action on Region not hiding Region Title

I'm using APEX 4.0.1 with theme 13.I've created a Dynamic Action to show/hide a region on my page but although the contents hide as expected, the Region Title remains. Any idea on how to hide the Region title as well?To identify the region to the DA I'm using the following method:Region Header <d ...

Oracle scrolling data in a region

Is there any way to have true scrolling of the data output of a region?Using region header footer div tags isn't really scrolling the data itself, just the first set. I still have to use the pagination options (which don't include scrolling).I'm using 1.5 still - is this all solved with 1.6 ? ...

header redirect to subdomain issue with cpanel

HiOn my site root in index.php I want to redirect to a subdomain with:if ($_COOKIE["region"]) {// redirect to regionheader ("location: http://www." . $_COOKIE["region"] . ".argyllnewmedia.co.uk");exit;}I have subdomains set up in Cpanel which redirect for exam ...

Oracle Column header format changes

I am using the following syntax to change the report regions (Theme 12. Standard) column headings font size by placing the following code in Region header of the report region; but this is not working. Please help me to fix this issue.ThanksLeo.. <style type="text/css">.t12standard th.t12heade ...

Oracle Regions in APEX

I want to display more than one Region Source in a Region... For exampleI have a Region which displays all of the contents of a Query. I want to have another query which does a count of all the records of the original Query above, possibly at the Region Header.Region Header: COUNT OF(Query1)Region B ...

Oracle Image display in HTML region

I'm unable to display image in HTML region, I'm using this syntax for displaying the image<img src="#IMAGE_PREFIX#IT logo.jpg">first i uploaded the image to "Shared Components" - "Images" .then referencing the image in one of the HTML Region in "Region Header".When i run the report i see "X" i ...

Oracle Using Apex Item

I have been spending a bit of time working with creating page items using the apex_item package. So far I have been successful in creating a procedure that will produce various components, and I then call that procedure from a PL/SQL region within one of my apex pages.The page is produced, but when ...

Oracle Region width based on user's screen resolution

I have a region that will always be wider than a user's screen width. I am trying to create a dynamic div that will be based on the user's resolution. I created a function and I can see the result in a display only textbox. However, I am not able to create a div with this as part of the style attrib ...