Forms :: Alert Windows Appear To Be Hidden And Application Locks Up

May 6, 2011

I have a forms 11g application that of course has several message and alert windows that pop up when various errors or messages need to be displayed. This all works great on the developer machine, but when I try and run the form on another machine using any browser the message and alert windows appear to be hidden and the application locks up with the rolling bar across the bottom. I would guess it is waiting for a response, but I cannot get the window to appear.

Following is an example of an alert to be displayed:
declare
vAlertButton number;
begin
vAlertButton := show_alert('NO_EMAIL');
end;

View 1 Replies


ADVERTISEMENT

Application Express :: Default Value For Hidden Item And Populate Query?

May 8, 2013

1.-) i got a page that contains 2 regions, lets say :master (HTML text) and a detail (tabular form updateable report) in my tabular form i got a hidden item that should take the value from the master form. how do i do this ?

2.-) i am calling a form from another form, sending a couple of fields as a link parameters. the second form is called as expected, but i need that records on the second form that match the parameters get displayed. how do i achieve that ?

View 6 Replies View Related

Application Express :: ReCAPCHA Plug-in Creating 3 Hidden Field

Sep 6, 2012

i m using Apex4.1 and data base oracle 11g, browser firefox

i m using recaptcha plugins i had tried it with both way by creating 3 hidden field and and also directly with taking a item based on plugin. URL.....

More specifically, the page has two items for user input (the captcha and a text item) and a Submit button. If the captcha is successful, then the text item will be submitted and redirect to another page. The problem I'm running into is that the text item is always submitted regardless of the captcha.

View 0 Replies View Related

Application Express :: Set Hidden Or Expanded Mode Of (Hide And Show Region) In 4.2

Sep 12, 2013

I just created a "Hide and Show Region" from a template in APEX4.2, and would like to control the behaviour of this region, i.e. 

1. At the page load, this region should be in "Hidden" mode
2. Once the user Opens the region, it should stay as "Expanded" mode ( even the page gets submitted), until the user chooses the "Hidden" mode again. 

So I tried the following

1. Chose the Hide and Show Region(expanded) template for the APEX region
2. uses Dynamic action to force the "Hidden" mode by setting Style as style="display: none;"  at the page load event. 

But it still shows the region in  "Expanded" mode after the page gets loaded.

View 0 Replies View Related

Forms :: Open Application Word 2010 With Forms Developer 6.0 - Windows 7?

Apr 20, 2011

I have u na forms developer application in 6.0 that generates a Word document. This application runs successfully on Windows XP operating system. We now have PC's new operating system Windows 7 and officce 2010. My procedure reads a specific route where a template in Word which is used to generate the document. In the user's PC application that does not generate the document even shows me an error message. But when I enter my network user with the user's PC and the document genre generates me perfectly. I checked if the user has access to the server path specifies where the template encuntra wish to open and if you have them.

View 1 Replies View Related

Application Express :: Enable IR Search Field To Search In Hidden Columns

Jul 15, 2012

I am using apex 4.1. I must hide phone number columns in my IR report, but at the same time the values of that columns should be available to search for using IR Search Field. is there a way to do this ?

if not, that means I have to :

1- Add a text filed P1_PHONE
2- edit my report query to something similar to
> Select * from Table where :P1_phone in (mobile1,mobile2) or :p1_phone is null
3- add button to refresh the report.

but the item P1_PHONE should be on the header of the Report region. is there a way to do this.
I am using theme 23
page template without sidebars
Report template : Reports Region.

how to put the item P1_PHONE on the tab of the page. Just similar to the Search item of in the Application Builder.

View 7 Replies View Related

Forms :: 10g Application On WINDOWS 7 And IE 8?

May 4, 2010

when am trying to open my Oracle 10 Forms Application on WINDOWS7- IE 8 explorer am getting the below error message.

"it has encountered a problem and needs to be close"

View 3 Replies View Related

Real Application Clusters :: Alert Log Clean Up In Rac?

Jun 18, 2012

is there any alarm in moving alert logs generated in the grid infrastructure. The alert log in the grid log directory has grown around 2gb .Our CRS version 11.2.02. on linux. Also pls, Sample script for automating the same.

View 4 Replies View Related

Forms :: Migrate Application From Linux Platform To Windows 7?

Oct 17, 2010

I'm trying to migrate our forms application from a Linux platform to Windows 7. We have a common pll which is attached to all forms and unfortunately relies heavily on globals.

Attempting to run the application with the standard library attached to the login form has the effect that the globals are lost between the login form and subsequent forms. If I incorporate the library code directly into the login form, it functions correctly. If I use the debugger to track where the clearing occurs, it functions correctly.

View 2 Replies View Related

Application Express :: How To Show Alert Message In Home Page

Jun 11, 2012

I have leave application form based on the LEAVE table, it has the following columns,

leave_id(primary key)
emp_name
from_date
to_date
no_of_days

Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?

View 5 Replies View Related

Application Express :: How To Show Alert When Data Not Exist In Table And Clear Field

Jun 8, 2012

Recently i created a form which contains emp_name,deptno,supervisor_name.For emp_name if i type the emp name (eg:allen) it will show me a list of employees named allen as a select list.For that i used a jquery script on page header

<link rel="stylesheet" href="URL.....
<script type="text/javascript" src="URL....
<script type="text/javascript">
[code]....

and i have created a dynamic action for emp name to fetch the deptno,supervisor_name if select the employee name it is working fine is if i type a emp_name which doesn't exist in the employee table it will show me a alert message employee does not exist and it will clears all the fields.

View 0 Replies View Related

Forms :: Data Have Been Displayed Normally / Tree Data Is Hidden With No Error

May 10, 2010

i'm use oracle form builder 6i when i use tree item to display data

the data have been displayed normally but at runtime when i resize the window the 'tree data' is hidden with no error.

View 1 Replies View Related

Forms :: Pop-up Or Alert On Desktop?

Nov 10, 2012

i am using .dot net frame work to show a pop up on desktop like reminder , can i do that using any oracle tools i am using oracle 10g along with forms 6i , i am using one query for this.

View 4 Replies View Related

Forms :: Alert While Deleting The Record

Mar 20, 2013

I want to create one alert while deleting the record from the custom form. So i have written the below code in the when-remove-record trigger.

DECLARE
alert_button NUMBER;
BEGIN
IF :XXWIPRELFRM.PRINTED = 'Yes' THEN
alert_button := SHOW_ALERT ('DELETE_ALERT');

[Code]..

When i click on the delete(X) symbol in the form, it is showing alert but when i click on "No" also its removing the record..what i need to write.

View 7 Replies View Related

Forms :: How To Display First Canvas Before Alert

Aug 31, 2010

I need to display my alert prompt right after I detect the discrepancy on amount. I place my code on POST-BLOCK. The problem is, after the query, the alert pops out right before the new canvas where the block with POST-BLOCK trigger shows.

I need to display first the canvas before the alert but seems like the process of displaying canvas is the last job oracle does. So even if I place my code on post-record or any other trigger it will be the same.

View 1 Replies View Related

Forms :: Raise Alert When Browser Closed In 11g

Feb 27, 2012

I am working on Forms [32 Bit] Version 11.1.1.4.0 (Production). OS is Win 7 (32 bit). Internet Explorer 8. My Requirement is I need to raise an alert when user close the browser window before closing the Form.

View 2 Replies View Related

Forms :: Calling Multiple Reports Through Alert

Feb 15, 2011

I need code for calling two reports using alerts.

View 4 Replies View Related

Forms :: Alert Cancel Button Gives Non Oracle Exception

Jan 20, 2011

i've created an alert with 2 buttons and the code for cancel button is as follows:

...
if alert_id = alert_button2
then
raise form_trigger_failure;
end if;
...

this code is in a pll and when called from a form it displays a non oracle exception message. How to do nothing when the user presses cancel on alert pop-up? apart from using null instead of raising the above exception?

View 5 Replies View Related

Forms :: Creating Alert After Records Retrieved From Query

Jun 26, 2013

I want to raise a alert after the records retrieved from a query. i.e, if the query fetches 0 records then the alert show be displayed. Is is possible? If yes tell me the trigger to be used to raise such kind of alert.

View 4 Replies View Related

Forms :: How To Create Library Functions To Show Alert

May 24, 2010

Am using Oracle 10g Forms and Databse.

My form Consists data block blk_user with two items username and password

Both user name and Password are required Fields.

When user left these items Empty To show Alert

I Created Below Procedure and Called in Form_Level ON-ERROR Trigger.

PROCEDURE pcd_io_alert IS
itm_name VARCHAR2(20);
BEGIN

[Code].....

how to call or create this procedure as Library functions and call the created library in form To Show Alert. Actually I want to create library functions to Validate and Show Alert Mesages.

View 1 Replies View Related

Forms :: Customize Position Of ALERT Message On Screen As Per Requirement

Mar 19, 2010

I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.

View 4 Replies View Related

Forms :: Display Alert When Click On Insert Record In Tool Bar?

Jun 26, 2013

I want to display an alert when we click on Insert Record in tool bar. I put allow update->yes and insert->no.

but when i click on the insert record in tool bar it showing message only.

Instead of message I need an alert using triggers. I added the image also.

View 1 Replies View Related

Forms :: How To Hide / Suppress User Defined Alert Messages

Dec 19, 2011

Is it possible to hide/suppress an user defined alert message in Oracle Forms application?

View 1 Replies View Related

SQL & PL/SQL :: Detecting Hidden Characters

Jul 31, 2011

I am not sure if the problem is related to hidden characters but its my best guess so far. I am trying to enhance a part of the ERD by creating a lookup for a column one of the table that uses text (finite set of values).

CREATE TABLE N_AGREEMENT_STATUS
(
STATUS_ID NUMBER(2) PRIMARY KEY,
STATUS_NAME VARCHAR2(10 BYTE)
);
INSERT ALL
INTO N_AGREEMENT_STATUS VALUES (1, 'INACTIVE')
INTO N_AGREEMENT_STATUS VALUES (2, 'ACTIVE')
INTO N_AGREEMENT_STATUS VALUES (3, 'CLOSED')
INTO N_AGREEMENT_STATUS VALUES (4, 'CANCELLED')
SELECT * FROM DUAL;

when I try to update the source table no update takes place (0 records updated) if I used the following statement:

ALTER TABLE N_AGREEMENT ADD STATUS_ID NUMBER(2);
UPDATE N_AGREEMENT SET STATUS_ID =
(
SELECT STATUS_ID
FROM N_AGREEMENT_STATUS
WHERE N_AGREEMENT.STATUS = STATUS_NAME );

but it works fine only if I used:

UPDATE N_AGREEMENT SET STATUS_ID =
(
SELECT STATUS_ID
FROM N_AGREEMENT_STATUS
WHERE N_AGREEMENT.STATUS LIKE STATUS_NAME || '%'
);

The strange thing is that when I use:

SELECT N_AGREEMENT.STATUS, N_AGREEMENT.STATUS_ID
FROM N_AGREEMENT
WHERE N_AGREEMENT.STATUS = 'ACTIVE';

it returns correct results and all status = 'ACTIVE' appear correctly!

View 20 Replies View Related

How To Get Information Of Hidden Parameters

Sep 16, 2012

)How do you view the value of the parameter that is being used by instance? show parameter..?
2)How do you get the information of hidden parameters
3)What is the database object that stores information related to various types of db connections over network
4)How do you verify since when the db session is running
5)How do you verify the Originating machine details of the database session
6)How do you verify the name of program that the db session is running
7)What is the naming convenion of Base tables. Where is the information of base tables stored?
8)How are dynamic views created. Whre is the information of dynamic views stored?

View 8 Replies View Related

SQL & PL/SQL :: How To Create Hidden Column In Table

Feb 15, 2012

I want to create a column which will be having unique values but while selecting data from table i am not willing to display same column in output.

SQL> create table temp
2 (
3 c1 number,
4 c2 number,
5 c3 number
6 );

Table created.

SQL> insert into temp values (1,2,3);

1 row created.

SQL> select * from temp;

C1 C2 C3
---------- ---------- ----------
1 2

I want C3 as a hidden column and while selecting like

select * from temp;
expected output is...

C1 C2
---------- ----------
1 2

My main target is, C3 column should not display in select * ... stm but column with data should be there in table.

View 7 Replies View Related

Locks On Partition Table?

May 13, 2011

I have the below questions on the locking mechanism in a partition table. Example I execute the below query,

delete from table_name subpartition (subpartition_name);

In that case,

1. If we perform above query, then which level of lock is happened to the table/partition & sub-partitions?

2. If we perform above query on same sub-partition of the same table with different where clause, what will happen?

3. If we perform above query for same table but different sub partition at same time, what will happen?

View 2 Replies View Related

How To Check Locks In Database

Apr 13, 2013

oracleDatabase version:11gR2

Os:solaris

how to check locks on database objects .it might be any lock? any select sql query to check database object levlel locks?what basis locks will occur?

View 3 Replies View Related

SQL & PL/SQL :: DB Locks And Data Corruption?

Feb 25, 2012

I have a sql script where triggers, procedures and functions are written. The triggers are causing db outages and causing problems in the application as well.

I am trying my best but with my low experience and expertise, am not able to make good progress.

Scenario: Course enrollments are inserted, deleted and updated in course_main and course_users table. This is done in gui as well as in background snapshot scheduler in a cron process. Course_main table contains all course enrollments and course_users table has crsmain_pk1 as foreign key.

Its quite a big file and am not sure what should i paste here so am uploading the file in txt.

View -1 Replies View Related

Dead Locks - Not Releasing?

Oct 8, 2012

We have encountered dead locks in EBS R12 Database 10.2.0.3. Even after bouncing the appstier and dbtier completely does not release the locks. How to clear the locks?

View 4 Replies View Related







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