Forms :: How To Read Application URL Runtime

Apr 21, 2009

Is it possible to read the application URL while running the application

[URL]

Above is my URL i need to read i and t hold it on a variable at runtime

View 3 Replies


ADVERTISEMENT

Application Express :: Possible To Set Application Availability In Runtime-only Environment?

Sep 6, 2012

I'm using apex 4.1.1.00.23.I'm wondering whether it is is possible to 'freeze' a production APEX application in a runtime-only installation, during an upgrade. I want to prevent strange behaviour for logged in end users. In the application builder one can set the availability of the application. I was thinking of making the application unavailable during the upgrade. Is this possible in a runtime only env? How? Or are there (better) alternatives?

View 1 Replies View Related

Application Express :: Pass Header Variable From OAM To Apex And Read It In Application?

Mar 4, 2013

We have integrated Oracle Access Manager 11gR1 with Oracle Apex 4.1. The OAM-Apex integration is working fine. Now we want an additional header variable to be passed from OAM to the Apex application. This new header variable will be user's sAMAccountName in Active Directory. OAM is integrated with AD and the AD users are successfully able to access the Apex applications.

The three header variables which are configure in OAM right now are:
Header variable name Value
1. OAM_REMOTE_USER $user.userid
2. OAM_REMOTE_USER_EMAIL $user.attr.mail
3. OAM_REMOTE_USER_GROUPS $user.groups

We need an additional header variable as mentioned below:
Header variable name: OAM_SAMACCOUNTNAME
Value: $user.attr.samaccountname

The new header variable was added in the OHS server's dads.conf file like shown below:
=========== dads.conf =============
...
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_GROUPS
PlsqlCGIEnvironmentList HTTP_OAM_REMOTE_USER_EMAIL
PlsqlCGIEnvironmentList HTTP_OAM_SAMACCOUNTNAME

But we are not able to read the value of this attribute in the Apex application.On the Apex application, we have a text box which shows the value of this header variable. This textbox is attached with the following stored procedure call to fetch the header variable:
===================
begin
:P1_HEADER_VALUE := owa_util.get_cgi_env( 'HTTP_OAM_SAMACCOUNTNAME' );
end;

The textbox shows the correct value if HTTP_OAM_REMOTE_USER is passed to the get_cgi_env method but does not shows anything when HTTP_OAM_SAMACCOUNTNAME is passed to the same method. if I am missing some configuration to pass the HTTP_OAM_SAMACCOUNTNAME haeder variable from OAM to Apex.

View 1 Replies View Related

Application Express :: Delete Read Only Application From A Workspace?

Oct 12, 2013

What can I do if I want to delete read only application from a workspace?

View 1 Replies View Related

Application Express :: How To Change Column Type At Runtime In 4.0

Apr 3, 2013

I´m newbie as Apex developer using Apex 4.0 with OracleXE 11.2, and now my problem is:

I have a tabular form where one of the columns, when calling the form, is a Display Item, so that you cannot change existing values​​.

I want, when adding a new row, that column become a Select List (named LOV) based on a query that exclude existing values ​​in other rows already inserted.

Can I change that Display Item to Select List (named LOV) programmatically at runtime? If not, what other options do I have?

View 13 Replies View Related

Forms :: List Forms Global Variables At Runtime

Jan 9, 2012

we are currently migrating from forms 6i to 11g. We would like to cleanup our global variables at runtime.

Is there any way to list the global variables at runtime?

View 2 Replies View Related

Application Express :: Dynamic Reports - Runtime Parameter Passing To Report Query

Jul 27, 2013

I have developed a report using apex shared components (report query and report layout) along with BI Publisher for report printing in pdf format. the Report template is built using Template Builder for Word. I have configured my Apex4.1 env with BI Publisher 11. This report is working fine for hardecode ID ( like REQUEST_ID=10 ).  to make report dynamic i have made following additions in the report 

I have added where clause in report query as WHERE REQUEST_ID = :REQUEST_ID (:REQUEST_ID is the text field in my page).

Added a text field names :REQUEST_ID to get user input at run time.

Create a button and add Repot Query URL in its properties. When i run the report with some valid value in :REQUEST_ID text field  i did not get expected result infect there is no record getting displayed in the PDF file. i think this is not the write way to do this but interestingly im not getting any error. how can i get this functionality in apex this way or the other ?

View 0 Replies View Related

Application Express :: Set Value For Read-only Field?

Sep 22, 2012

I have a form that based on a table,

Col1: text field
Col2: text field with Disabled =Yes and Save session state = Yes

I create a dynamic action on Col1 to set value for Col2, when I submit page an error raised: Session state protection violation

visit: [URL]...

My purpose is: Col2 is set value by Col1 via Dynamic action, and is read-only, user cannot modify.

View 7 Replies View Related

Forms :: Display Multiple Forms At Runtime

Oct 13, 2009

is there a way to keep the display of the form when we call another new form. my scenario will be as following:

am in form1 , i call form 2 from a menu, after this call form2 is open in place of form1.

i have no control in form1 and i can't change anything on it, i don't know hw the menu option is calling form2.the only control i have will be within form2 if there is any change i can make it.i read something about MDI, and OPEN_FORM() procedure, but i think this will required a change in form1 which i can't do.

is there any change i can make in form2 to display it and keep the display of form1 at the same time behind it ?

View 5 Replies View Related

Forms :: How To Get Reports Runtime

Nov 27, 2011

How can I get forms and reports runtime and from where?

View 2 Replies View Related

Forms :: Getting Runtime Remarks?

Aug 12, 2010

find the attached file.i want to get the remarks on runtime.i have written this formula in when_validate_item.

declare
a number;
begin
a := nvl(:get_mark,0);
if a >= (33/100)*:get_mark then
:remarks := 'PASS'

[code]...

View 4 Replies View Related

Application Express :: Cannot Read Table In Other Schema Even With Qualifier

Jun 8, 2012

I had a situation last year where I could not login as myself or see any objects in my schema. Some code using APEX methods to create a new APEX user, and it finally worked.

The new user, ADMINUSERS suddenly had its password expire and I could not reset it, so I repeated last years’ effort but this time nothing worked.

Now I have a problem where I cannot even read a table if it is in another schema, even if I use the schema name as a qualifier. This happens even in SQL plus, except when I login as System I can read tables in other schemas if I prefix the table name with the schema and a dot. But this does not work with other users, even though I have granted the other users the role of dba.

View 17 Replies View Related

Application Express :: Text Areas In 4.2.2 - Can't Be Read Dynamically

Sep 3, 2013

i encountered a big problem after upgrading Apex from 4.1 to 4.2.2. On an application page there is a Text Area which will be read and processed after clicking a button. I didn't want a refresh of the page and did it with a dynamic action.All this worked like a charm with 4.1. Since the upgrade, the value of the Text Area is always returned as null while processing the dynamic action, but the value is filled by the user!When i change the type of the Element to Rich Text Area everything works fine, but i don't want this because i don't want HTML in the corresponding table. Is this a bug? How can i workaround it? 

View 10 Replies View Related

Application Express :: Select List Read Only / Or Display Only

Sep 3, 2012

I have Select list itemS based on Lookup tables. When the form in Edit mode, I want to prevent the end user from changing the value of these Select list items. How can I accomplish this ??? **If I change the type of the item to Display only, then it will show the returned value of the Select list.

View 1 Replies View Related

Application Express :: Conditional Read Only That Saves To Database?

Nov 27, 2012

I have an item that does not save to the database.it is conditional read only based on the value in another column, when it is not read only it displays as a Select list.. then whatever is chosen triggers a dynamic action that sets other items.so setting it as a display only is not an option.

after upgrading from 4.0 to apex 4.2 this gives error:   Session state protection violation: This may be caused by manual alteration of protected page...

the only workaround I have found is to set the Read Only to none, then create a dynamic action that conditionally sets the field to disabled..This works, but my problem with it is that it looks different than the read only..read only was Black Text and no textbox..disabled is a text box with greyed out text that is hard to read for some of the users..

View 4 Replies View Related

Forms :: How To Add Text Items At Runtime

Dec 24, 2012

I want add a text item at run time depending on the number of values retrieved i want to change the number of text items. Is it possible at run time to add a text item?

View 1 Replies View Related

Forms :: Change Image In Runtime?

Nov 10, 2011

how can change image through runtime i mean if have 5 pictures first image will showing and second image showing

View 1 Replies View Related

Forms :: How To Hide A Button While Runtime

Mar 30, 2012

We have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.

Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?

View 2 Replies View Related

Forms :: Setting Icon At Runtime

Feb 12, 2010

i want to set the icon on my forms i write these lines.... for to do this...

MDI_ICO := WIN_API_UTILITY.GET_ACTIVE_WINDOW;
WIN_API_SESSION.CHANGE_MDI_ICON(MDI_ICO, '.IconsCOMPANY.ico', 0);

and i also attached the library d2kwutil.pll and when i run the form then this error raised...

FRM-40734: Internal Error : PL/SQL error occurred..

now what can i do for set the icon at run time..the first part of the message has been removed as it belongs to @allianz2010's previous topic; the rest has been split into a new.

View 1 Replies View Related

Forms :: Text_items Are Not Visible In Runtime

Apr 3, 2013

I have one form that is migrated from oracle forms 6i to 11g. I opened that form by 11g form builder and it has 3 text items. Then i run the form from 11g builder...here is my problem, only 2 text items are displayed in my browser(IE). another one is invisible... i checked the property pallet for that particular text item.

i checked the following properties and its value in my form:

enabled=yes
visible=yes

but the text item is not visible.

View 2 Replies View Related

Forms :: Create Runtime In Oracle 10g Like 6i?

Sep 27, 2013

Can We Create Forms Runtime in Oracle Forms 10g Like Oracle Forms 6i

View 1 Replies View Related

Forms :: Positioning Canvas At Runtime

Apr 26, 2012

i need to position my canvas at run time.

View 3 Replies View Related

Forms :: Read / Write In Unix From Oracle Forms Installed In Windows

Nov 24, 2011

I have a requirement to read a file from windows m/c and write into Unix Server. How can i do that in Oracle forms.

I tried TEXT_IO package.But that is not allowing to access Unix path.

View 2 Replies View Related

Application Express :: Change Read Only Condition From Always To None On Real Time

Sep 4, 2012

Can we change the condition of an item from always to none on the real time ? How ?

View 3 Replies View Related

Forms :: How Column Name Of A Database Can Be Changed At Runtime

Feb 20, 2012

My form has to go into two different environment in which the one column name of a table is different. datatype is same.

I would like to change the database column name of the item in the form for that block at run time.

View 2 Replies View Related

Forms :: How To Run 6i From Server Without Runtime Installation On Client PC

Sep 20, 2013

How To Run Forms 6i from Server without Runtime Installation on Client Pc.

View 5 Replies View Related

Forms :: How To Change Default Runtime Logo In 6i

Feb 5, 2012

How can I change the default runtime logo in forms 6i.

View 1 Replies View Related

Forms :: Developer 9i AS Icons Disappear At Runtime?

Apr 15, 2010

I develop a form using Devloper9i AS, oracle 9i, Winxp. The problem is: I used icon button at design view ".fmb" but at run time this icon disappears in the file ".fmx" After reading some topics covered this problem in this forum; The following steps are executed:

1-In regedit I put UI_ICON = c:icon --where my gif icon file is located

2-At command prompts i type: C:>jar -cvf icons.jar c:icons Then "ICONS.JAR" file is created on D:Dev9ijdkin

3- I Copy the file "ICONS.JAR" and past into D:Dev9iforms90java

4- I modify the "FORMSWEB.CFG" as follow:

archive_jini=icons.jar,f90all_jinit.jar;
imageBase=codeBase

4- In "Registry.dat" I added the flowing line:

default.icons.iconpath= c:icons

5- I modify the "orion-web.xml" .as follow:

<virtual-directory virtual-path="/html"
real-path="D:Dev9i/tools/web90/html" />
is modified to :
<virtual-directory virtual-path="/ICONS"
real-path="C:ICONS" />

6- In the property palette for the icon item and in the Icon Filename I put just the icon name called "w_prev" Without any extension , any path...

View 34 Replies View Related

Forms :: How To Display Runtime Calculation In Cursor

May 18, 2010

How To Display Runtime Calculation in cursor for example in loop i define xyx number then add + 1 in xyz and move its value to block item until loop valid but in display no value shown but if i apply message(xyz) then it also shown the answer is correct but with message style i click every time in message but i want that with some delay form automatically show the value of xyz in block field.

View 3 Replies View Related

Forms :: Change Item_type Property At Runtime?

May 9, 2012

Is it possible to change the item_type property of an item at runtime.

I have one text item and i need to lock(Read only) that item. I hope we can change the ENABLED property or by changing the ITEM_TYPE as DISPLAY_ITEM.

How to change the Item_Type to DISPLAY_ITEM from TEXT_ITEM at run time or else is there any other way except ENABLED property to male the field as READONLY.

View 2 Replies View Related







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