SQL & PL/SQL :: Session Aborted After Closing Window?

Nov 24, 2010

I created following table and procedure

create table t(n number);
create or replace procedure prc as
begin
insert into t values (1);
commit;
sys.dbms_lock.sleep(10);

[code]...

I opened 2 sessions

from session -1, I executed

exec prc

from session -2, I executed

select * from t;

In the middle of the execution when I had following values inserted into t, I closed the sql window of session where I was executing the process prc

select * from t;
n
--------
1
2
3

and found that the session got terminated and no values inserted into table t after this.

I may be missing some basic oracle stuff here but I was expecting the session would continue running on the server inserting values in table t upto 6.

I would like to know in which case a session executed from sql client will continue even while the sql window is closed?

View 12 Replies


ADVERTISEMENT

Application Express :: ORA-56720 - I/O Data Limit Exceeded - Call Aborted

Sep 16, 2012

I have a workspace on [URL] I tried to copy an application. It gives me

GET_STMT error. ORA-56720: I/O data limit exceeded - call aborted:281:0

ORA-56720: I/O data limit exceeded - call aborted

View 3 Replies View Related

Enterprise Manage Console Closing Automatically?

Jul 25, 2013

I have successfully installed the Oracle 10g standerd version with a sample database on Windows server 2008 standard server. Then I installed the client so that I could use the Enterprise manage console that comes with it. Once installed, I was able to successfully configured the Net service. Now when I use either Enterprise manage console or SQL plus to login to the service that I created, once I enter the user id and password and click ok, system automatically closes both applications. I am not sure what is missing. I installed the same client on a windows XP pc and the enterprise manage console is working perfect.

View 1 Replies View Related

Forms :: Layout Not Opened - Closing And Giving Error?

Jul 28, 2011

i'm not able to open layout in the custom form.automatically it will be closing and giving this error. Oracle Forms Designer has encountered a problem and needs to close.

View 5 Replies View Related

Forms :: FRM-40202 Field Must Be Entered Dialogue Not Closing

Sep 29, 2011

I am making a field mandatory dynamially by set_item_property to Required Yes.So when i left it blank it is displaying the error Frm-40202, it's fine. But when i closing this error message by clicking on OK button to enter the field it was not allowing me to navigate into the field. The same error message is reopening.

View 2 Replies View Related

LGWR / Error 1041 Closing Archive Log File (STANDBY)

Jun 30, 2010

I have configured data guard in the windows XP same server .It is not able to apply log to the Standby database.when I queried the following, I go the following erros..

sql>select message from v$dataguard_status where dest_id=2;
FAL[server, ARC0]: Error 12514 creating remote archivelog file 'STNDBY'
PING[ARCk]: Heartbeat failed to connect to standby 'STNDBY'. Error is 12528.
LGWR: I/O error 1089 archiving log 1 to 'STNDBY'
"ARCk: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
"
"ARCk: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
"
PING[ARCk]: Error 3113 when pinging standby STNDBY.
"LNS: Closing remote archive destination LOG_ARCHIVE_DEST_2: 'STNDBY' (error 1089)
"
LGWR: Error 1041 closing archivelog file 'STNDBY'
************************************************

Also if

SQL> select sequence#,applied from v$archived_log;

query gives the following message----

SEQUENCE# APP
---------- ---
7 YES
5 NO
8 NO
9 NO
6 NO
10 NO
10 NO
11 NO
11 NO
12 NO
12 NO

View 4 Replies View Related

Application Express :: Kill Current Session When Another Session With Same User Starts

Nov 19, 2012

I have an urgent requirement to kill an existing session if a new session starts for the same user. I have been reading lot of blogs and posts on the above topic, but could clearly tell me how to do it.

I thought of putting a process in 101 page when login button is pressed to catch this and kill the old session.

View 7 Replies View Related

Application Express :: Refreshing Tabular Form On Closing Modal Page?

Nov 14, 2013

I am not able to refresh tabular form region on close of the modal page. 

View 6 Replies View Related

Application Express :: Refreshing Main Page After Closing Skillbuilder Popup?

Aug 17, 2012

I need to refresh my main page after closing the popup page displayed by skillbuilder plugin

apex 4.1.0/Oracle 11g Ent.

View 9 Replies View Related

Application Express :: (X) Process Taking 60% CPU In Two Session (30% Each Session)

Oct 23, 2012

We are using Apex 4.0/Oracle 10gR2/ Hp-Ux, We noticed that there is a process Running in Two Sessions that seems running since 3 Hours using 60% CPU,** 30% given below sql it executes in two Sessions!

declare function x return boolean is begin -- if instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY')>0 then
declare
l_position number := 0;
begin
loop
l_position := instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) ;
exit when instr(upper(:F4000_P4651_PLUG_SOURCE),'ORDER BY ',l_position + 1) = 0 ;

[code]....

View 4 Replies View Related

Forms :: Enable Property Of One Particular Text Item To False - Form Abruptly Closing

Sep 8, 2011

i have a form having 4 database data blocks and one non database data block(for Push Buttons like SAVE,CLEAR,EXIT..).

In the control Block i have 5 push buttons out of which one is used to Save the entries and one to clear the form. In the coding of SAVE button after writing "COMMIT_FORM;" i want to disable all other Data block on my form excluding the one containing Push buttons so that the data entered by end user stay appearing on the form till he Clears the form.

Now the problem is that when i set enabled property of one particular text_item to false , the form if closing down along with the application, it is totally disappearing from screen.This is happening for one particular text item.

what could be the possible reason for this and what needs to be done to overcome this problem.

View 5 Replies View Related

Grant Select On V$session And Gv$session Directly?

Aug 28, 2013

Instead of giving permission directly to v$session and gv$session to a developer, Is there any other way to do the same?

View 3 Replies View Related

Forms :: How To Reload Calling Form After Closing Called Form

Jul 15, 2007

I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.

How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?

View 13 Replies View Related

Forms :: How To Get Window Handle

Feb 9, 2010

The following code works fine in the form 6i, but in the same form 10g I get map_handle='0' and win_handle='0' instead of certain value as in 6i.

map_handle:=get_item_property('MAP.MAP_ITEM',WINDOW_HANDLE);
win_handle:=get_window_property('CG$WINDOW_1',WINDOW_HANDLE);

MAP.MAP_ITEM has Chart Item type.

View 3 Replies View Related

Full And Incremental RECOVERY WINDOW

Sep 5, 2010

I have RMAN configured TO RECOVERY WINDOW OF 7 DAYS;I do a Level 0 backup on SAT, SUN-FRI I do a Level 1 (all to disk)

After I do a successful Level 0 backup, why would I need to keep Level 1 backups around on disk?I know the recovery window is 7 days but is there any way to remove the other 6 days of Level 1 backups after a successful Level 0?To me this seems like a waste of space since I have a succesful Level 0 or am I missing something?

View 6 Replies View Related

How To Close Window In Oracle Forms 6i

Nov 27, 2004

code for "when button pressed" trigger that will close the current window and displays another window.

View 4 Replies View Related

Forms :: Call Another Canvas In Same Window?

Feb 22, 2013

I want to call another canvas in same window.using this code /it not work show_view('canvasname');

View 1 Replies View Related

Forms :: New Window Opened As Deactivated

Jan 15, 2011

i want to open a new window from my form. everything going well but when a new window opened. the control remains on previous form. and the new window is also inactive. i tried go_item with the item belongs to the new canvas but in vain.

View 14 Replies View Related

Forms :: Icon In Window Title Bar?

Jul 23, 2010

I am using Developer 6i and i want to know how to replace the default icon in form window title bar with company's logo.

View 1 Replies View Related

Forms :: Hiding Window Failing On 6i

Apr 24, 2010

I have to create a new window in a newly developed forms 6i (in Oracle e Business Suite 11i).

This new window is to duplicate the Oracle standard alert systems. I have to create a new one to match the style classes of the other windows in the developed forms. Actually, I did not manage to change the oracle alert I used first, to match fonts, colour and sizes defined in the customised class. Thus, I decided to create a new window and canvas.

It has to display a confirmation message with 2 buttons: OK, Cancel. This window contains a canvas displaying a confirmation message, and 2 buttons : Ok, Cancel attached to my data-block. I manage to show this window, with a show_window command, called from a button on the previous window's canvas.

I do not manage to hide this new window, and to come back to the previous one, when I click on Cancel button. The window does not hide.

View 8 Replies View Related

Forms :: Command To Maximize The Window

Mar 9, 2010

Some of the items are not getting displayed properly in my form when i run.I want all of them to appear on form. Can i maximize when i open.If so whats the command.

View 5 Replies View Related

Forms :: Tap And Toolbar Canvas In Same Window

Feb 21, 2010

I use forms10g in windows xp, i create a tap and toolbar canvases in content canvas but at runtime i can see only toolbar canvas.

View 1 Replies View Related

Forms :: Set Size Of Window In Browser?

Jan 22, 2013

how i can set the size of runtime window in My browser? I have a larg form ( 800 X 600 )

View 1 Replies View Related

Oracle 10g Instant Client For Window 7

Dec 18, 2012

There are three versions of Oracle 10g instant client (10.2.0.2, 10.2.0.3 and 10.2.0.5) on Oracle website. which one works with Window 7? Where I can find the documentation from Oracle website?

View 1 Replies View Related

Oracle 10g On Window 7 - Cannot Access EM By Using Command

Mar 6, 2012

I installed oracle 10g version 10.2.0.1.0 on window 7 sqlplus is working but when i try to access oracle EM by using command "emctl start dbconsole" it give error

"OC4J Configuration issue. E:\oracle\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_Console_192.168.1.3_orcl not found".

although i have assigned ip address as well .

View 3 Replies View Related

Forms :: Get Conditional Window Appear In Form

Jun 2, 2011

I want to achieve functionality like below:

Let's say there are two almost identical window and some specific functions associated: W1 and W2.

Depending upon the login profile into the application only one window and associated functions will be appeared. This time the other window will be disabled.

View 3 Replies View Related

Client Tools :: Installation Of Oracle 10g At Window 7 64 Bit?

Apr 3, 2012

can we install oracle 10g,developer 2000 at window7 64 bit

View 9 Replies View Related

Forms :: Close A Window In Query Mode

Apr 10, 2010

How do I close a window in query mode?My form has a button "Populate from Charge Master" which opens a window containing a List Item (Department Names) and 2 buttons,

1. "Select the Dept" and
2. "Cancel"

The WHEN-BUTTON-PRESSED trigger code for "Populate from Charge Master" button is as follows:

begin
SHOW_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
go_block('bl_med_dep');
enter_query;
end;

Code for "Select" button in the window is:

populate_from_charge_master(:bl_med_dep.med_dep_code,:bl_med_charge_party.charge_party_no);
execute_query;
COMMIT;
HIDE_WINDOW('WINDOW_POP_FROM_CHARGE_MASTER');
GO_BLOCK('BL_MED_CHARGE_PARTY');
EXECUTE_QUERY;

Code for "Cancel" button in the window is:

BEGIN
hide_window('WINDOW_POP_FROM_CHARGE_MASTER');
show_window('WINDOW1');
GO_BLOCK('BL_CHARGE_COMPANY');
END;

Here WINDOW1 is the main window and WINDOW_POP_FROM_CHARGE_MASTER is the window which must be closed when "Cancel" button is pressed.

When I remove "enter_query" statement in "populate from charge master" trigger code, I am not able to select any of the departments from the list. and If I have that statement, I am not able to hide/close the window.

View 5 Replies View Related

Forms :: Take Pic From Cam Window And Save It To Field In Database

Dec 21, 2012

I have a requirement to take pic from a cam window and save it to forms field in database.

View 2 Replies View Related

Forms :: Maximize Window On Secondary Screen

Aug 20, 2012

I've already check on internet and the forum if there is a way to maximize a window on the secondary monitor instead of the main one. There is a parameter to make that? or Oracle forms maximize the windows only on the main screen?

View 1 Replies View Related







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