Oracle Apex item in procedure

I have a procedure contaning a cursor returning values into an apex item.Now when i click on the Submit button , i want the values stored in the apex items entered into a table.but when i use for i in 1..APEX_APPLICATION.G_F01.COUNT loopinsert into tab1 values(APEX_APPLICATION.G_F01(1)); end loop;It ...

Oracle how can i use PLSQL anonymous block for an Apex Item.

P3_Item Display as Text (does not save state)I created an apex item like above what i have shown. I want to display a value for above item. For that i am trying to use PL/SQL anonymous block in the Source --> Source Type.facing below error 1 error has occurred* PLSQL anonymous block source type c ...

Oracle How to populate values in Apex item

I am using apex collection item to capture data my requirement is to calculate data using the apex item This requirement is like this. I am using a SQL query like this selectwwv_flow_item.TEXT(1,NULL,20,10) "A",wwv_flow_item.TEXT(2,NULL,20,10) "B",wwv_flow_item.TEXT(4,NULL,20,10) "C"from dual There ...

Oracle How to use apex item value in COLLECTION QUERY

How to use apex item value in COLLECTION QUERY ? ...

Oracle Apex item value to Javascript var

I´m trying to put the value of a apex Item into a javascript var. Coz i need to make a IF to do certain function, according to what the iten value.Like: <script>var a = :P2094_SUCESS;</script>but its not working,. there´s a way to pass values os apex itens to javascript variables??? ...

Oracle Setting value of APEX item through javascript

I am struggling to set the value of an APEX item from javascript.At the moment I have a button on Page 1 that has a action of URL. The URL points tojavascript:getConfirmation('&APP_SESSION.');and my function is <script type="text/javascript">function getConfirmation(sessionNumber){var answ ...

<textarea> scroll x

How can I get my textarea to scroll right and left? I'm using the textarea for entering HTML into a database, and I don't want the code to wrap around.I already tried using CSS like overflow:scroll-x; and overflow-x:scroll;, but neither one worked. :S ...

Oracle Apex Item Position....

Apex Community;Please resolve my problem I m very disturb about position seting of item in a form. Please tell me how I can set position of Item in apex form as I want. ...

Oracle Apex Item Problem

I am using a SQL Query to accept End user information using apex collection item, when i try to run the query i can see the out put some time when i refresh it shows page cannot be displayed also there is a insert process created when i click on submit button it shows page cannot be displayed this i ...

Oracle APEX Item details display while Create

Apex : 3.2.0Db : 10.2.0.4OS : Linux Issue : Displaying the details. I am 3 days old in Apex working. trying to understanding the working. I designed a small form with 10 fields. INSERTat entry field Item class I put a LOV as follows select class_id||' ==> '||Class_DESC d ,Class_id r FROM class_ma ...

Oracle Querying the paramater attributes of an apex.item

everyone, I was wondering if it's possible to query a cursor through the parameters specified for an apex api item (apex_item)?For example, I have a page where I have one global array - g_f02 - store the results of a large group of checkboxes, and another array - g_f03 - store the results of a large ...

Oracle Change "name" propertie of a apex item

I´m trying to change some atributes of a select list item, like "name", but the apex put a name like "p_t04", even if i put a (( name="mine" )) in the atributes of form elements, when i check the html source code, the name "p_t04" is in there. Apex set the ID of a item like the name i choose to the ...

Oracle How to pass apex item value to html source ?

I have an HTML area on an Apex page with the following hard coded value:<img src="#OWNER#.FILE_TO_BLOB?p_file_id=22"/> I have an item on the page called ( P90_LINK_DB_ID ) which will hold the value I would like to use with the above code, so it is no longer hard coded, I have tried: ...

TextArea scroll bar lowest position?

I am trying to get a scroll bar to go to the lowest position possible. I am using a chat program and it bothers me that I have to scroll down to see new messages! I googled around and found lots of answers for flash, and other languages but nothing that helped me ! ...

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 Check Interactive report filter with APEX item :P101_USERNAME

is there a way to create a filter with IR which is based on the :P101_USERNAME item?I use this variable with the windows user name and want to show only rows where the current user works with. ...

Oracle To make Apex item as Disabled conditionally.

I have an Select list item which i have made as disabled using java script ex: $f_DisableOnValue('Item Name', 'Value', 'Item Name'); which will be containing some value, And i have another select list with submit item below the 1st select list item. But whenever i try to select something from the 2n ...

Oracle Apex Item popupkey_from_query

I am using this wwv_flow_item.popupkey_from_query for populating the data in the popup window, If i use a where clause inside the item to populate the conditional data i am getting a following error please suggest me how to fix this issues. wwv_flow_item.popupkey_from_query(35,NULL,'SELECT object_ty ...

Oracle Using the Value of one Apex Item to Conditionally Filter Another

I have a SQL Query (updateable report) with a region source similar to the following: SelectNULL "CHECK$01",user,account_idfrom (selectNULL "CHECK$01",user,APEX_ITEM.SELECT_LIST_FROM_QUERY(3,account,'select unique account a, id b from accounts_db where acct_user = #USER# order by a','class="required ...

Oracle JQuery Datepicker and APEX Item for minDate

Can anyone provide suggestions on how I can use the JQuery Datepicker and set the minDate paramerter based on the value of a hidden page item $P2_DAYS_AHEAD. This item will contain a string beginning with a + or - followed by a number of days. Right now it works if I hard code this value into the ja ...

Oracle Cascading using Apex Item

APEX_ITEM.POPUP_FROM_QUERY(1,) // ITEM-1APEX_ITEM.POPUP_FROM_QUERY(2) // ITEM-2 Value passed by // ITEM-1 must be input for next item // ITEM-2 . Please let me know how to implement this please suggest me. ...

Oracle APEX.ITEM.popupkey_from_query does not populate the correct row

I have a manual tabular form that contains a popup field. When I click on the popup icon, it displays the popup window. I select the row that I want to populate the field with but it doesn't populate the field correctly. It usually populates the 2nd row but not always. I included the form in the Sam ...

Oracle Apex item giving error.

Database 11 G,Apex 3.2 Version.. i have created one Multiselect option ,in that LOV i have applied this follwoing query select name display_value, name return_value from scott.t_test ab where type = 'R' and ab.flag = 'Y' start with ab.name = :P1_NAME connect by prior ab.id = id ; After page run gett ...

Oracle referencing an apex item in the cursor of a sql report (item is a link)

Is there a way for me to reference my database link in the cursor of my pl/sql function body returning SQL query report? See bolded and italic section.declarev_sql varchar2(32000);cursor c1 is select distinct cpt_code from mv_prc_code_cnt@v('&F109_LINK.');beginv_sql:='select cpt_code,rank_plan f ...

Oracle fetch a value of apex item into javascript global variable

can anyone please help me out with this issue with javascript.I have items P0_DEPT and P0_EMP both of them are select list with submit items.Now I want get the values of these items in javscript global varibales. For this I have the following code which is not working returns nothing. The reason why ...

Oracle hidden apex item needed in report

basically i'm having a design problem since some apex_item.hidden items must have the show attribute to true in order to use the id's they hold. so the report shows empty columns and that an issue.-can anybody give advice on hidding these columns and still use the column values?i'm adding a screen c ...

Oracle javascript with apex_item.datepopup

I have a sql report like this :APEX_ITEM.DATE_POPUP(2,rownum,col1,'DD-MON-YYYY',11) "col1",APEX_ITEM.DATE_POPUP(3,rownum,col2,'DD-MON-YYYY',11) "col2",APEX_ITEM.DATE_POPUP(4,rownum,col3,'DD-MON-YYYY',11) "col3",APEX_ITEM.DATE_POPUP(5,rownum,col4,'DD-MON-YYYY',11) "col4",APEX_ITEM.DATE_POPUP(6,rownum ...

Oracle Multi Select functionality with apex_item type

I need to implement the multi select functionality for the report. Is this can be implemented with the apex.item. ...

Oracle Validate APEX_ITEM Using JavaScript

I am using apex item to validate items using javascript. selectwwv_flow_item.TEXT(3,NULL,2,10) "A",wwv_flow_item.TEXT(3,NULL,2,10) "B"from dualI want to check the values entered in A and B. If A is 0 or NULL or B is 0 or null. A message has to be shown.I tried writing raise application error. the va ...

Oracle APEX - Textarea with HTML Editor.

All,I am working with Application Express Version 2.2.1.00.04I have the following problem:I have an item "Textarea with HTML Editor" which I am insertinginformation CLOB in a table.This data is consulted by a Region Report of APEX which has a Link thatwill be a popup. Inside the report, I use wwv_fl ...

Oracle js form item value and ApEx form item format mask

I have a JS that shows an hidden form item (textarea) based on select list and currency value in amt field.The currancy form element amt is set to have a format mask $123,000.00.A complete solution for me is to display hidden textarea when select list value is 'Y' and currancy is > 250000. But be ...

Oracle Setting application item values outwith apex session

Is there anyway I can set the value of an apex item in a specific session outwith that session?I know what the session value will be so ideally id like to be able to use something likeAPEX_UTIL.SET_SESSION_STATE('P0_ITEM', value); but pass in the session value as well. ...

Oracle Bug Report: fck_link.html missing from apex download distro

I'm using the "Starndard HTML Editor" item in Apex 3.0I'm trying to edit a link in the body of the item textarea. The pop-up does come up but I get the following error inside the window:Not FoundThe requested URL /i/fck/editor/dialog/fck_link.html was not found on this server.I double checked origin ...

Jquery-Tools Scrollable, goto item?

I'm also looking for something similar to this....Quolte from another forum: "Is there a way to 'activate' an item in the list of items inside Scrollable? The thing I want to accomplish is this: call the api.seekTo() method inside a piece of javascript (this part works) and then visualy show th ...

auto scrolling in textarea

I'm currently working on a frame page where 1 of the frames would periodically update another frame's textarea with more information.However, as the information builds up, there textarea will not scroll down, can anyone tell me any code to let the textarea scroll down by itself? ...

Scrolling listbox selected item into view

In a listbox, I select one of the items programatically. It works, but that item doesn't scroll up into view.How do I force the selected item to scroll into view?int i = m_listbox.FindStringExact(-1,str);m_listbox.SetSel(i,TRUE);m_listbox.SetCaretIndex(i); ...

Oracle proble with Textarea with HTML Editor

I've this problem:I use an item Textarea with HTML Editor,but when I disabled this object I seeing the html tag in the tex box. is there any option to seeing the text only without the html tag? ...

Oracle APEX drill down - help !

I am very new to APEX. I have created a report region with a query like select APEX_ITEM.TEXT(3, DB_OBJECT_NAME) AS DB_OBJECT_NAME,from BC_ENTITIESwhere VISIBILITY = 'PUBLIC'This returns multiple rows of data. I want to create a dril-down on this. I have (a) added cloumn link on this item and provid ...

Scrolling a TextArea

I'm using TextArea.append() to add text to a textarea. Is there a way to make the textarea scroll so that the last line added always is visible? ...

Oracle How to access APEX variables within compiled pl/sql function.

My initial problem is to create pl/sql code returning column names for my custom calendar report.There are 7 columns for each day of the week and I want it to be on two rows - first the day of the week, such as 'Monday' and below it (with BR tag) the date, such as '18-08-2008'.What I want is to set ...

Oracle Can't get application item prior to page fully loading when using AJAX

I'm using the sample code found here: http://apex.oracle.com/pls/otn/f?p=11933:51:::NO:RP:: I have an application item named FOO and which has a value of BAR.if I do the following javascript in the header or in the body of my html page the result is an alert with no text: <script language="javasc ...

Oracle Colored background Item in Select List does not stay selected

I have an dynamic LOV I am using in a select list. Here is the code:select decode(a.st,'CT',a.st||' - '||a.st_name,a.st||' - '||a.st_name||'* ' ) d,decode(a.st,'CT',a.st,a.st||'" style="background-color:red;' ) rfrom STATES A where st in ('CT','MA','NH')order by a.st Here it what it looks like rende ...

Oracle Again submitting item position setting problem....

Apex communities;I have submitted this problem many time but I have not gotten any reply.Please resolve my little problem; I want to set apex item which created in form condition not in tabular form; but I want to set these item's position as I desire.Please tell me its simple solution in steps. Tha ...

Oracle Lock Item/Element

hiIn a form i want to lock the element or ItemSuppose i have a Item(Textarea) in a form,After Inserting value in Textarea when i click create button,i don't want to update textarea when i click Apply Changes button, but i want to display Textarea item.i.e I want to Lock the textarea, no one should u ...

Oracle Confused with performance using APEX Items in where clause vs. hard coding

I am rather confused as to why I am having a performance issue when using the APEX Item in my where clause versus just hard coding the values. I have a SQL that searches a list of invoices by date. When using APEX Items in my where clause, the report takes 15-20 seconds to run. However, if I hard co ...

Oracle How to avoid leading space -char(160) in Apex items

HiI'm getting a leading space in one of my apex item (text area).Further check reveals that it is char(160). Could any one help me in this to avoid leading space in the item.Many ...

Oracle sql report on item - problem with commas in the string

I have a simple report that groups all the Job Titles entered on our database. I pass the job title to an apex item and then on a second page list the records that match that job title using:and ed.ede_job_title = :P35_JOB_TITLEIf there is a comma in the job title the report returns the records that ...

Oracle Call query from database as item source

I have a query that is too long to paste it as the record source for an Apex item. It exceeds the limit of 32K.Is there a way to save that query at database level and call it from the apex item?If there is, please be so kind and give a small example! ...

Oracle How to freeze Interactive report header in APEX

Can anyone tell me how to freeze the interactive report header?My requirement is i have an interactive report which contains 1000 records. while scrolling the page i need the header. But in APEX when we scroll down the page to see the 1000th record the header will not shown in the page. Can we split ...

Oracle Date in Text Item showing wrong year

I have text item and PLSQL process that is selecting date from table into the apex text item. In my PLSQL I am converting date to TO_CHAR(date_column, 'MM-YYYY'). If the return value is 01-2008, Apex text item is showing this as 01-9008. I tried changing the apex item type to date and applying the f ...