Forms :: Open Dialog Window Using Oracle 10g
Jul 7, 2012i want to open dialog window using oracle forms 10g on button click event.
View 3 Repliesi want to open dialog window using oracle forms 10g on button click event.
View 3 Repliesi have oracle from 10g installed. i have added webutil libraries.and its has been complied succesfully.now i have a one button on form. on that button triggerd i want open dialog box to select the file.like browse.
for that i have used below command.
webutil.Client_Get_File_Name('C:','file_name.xls','XLS Files (*.xls)|*.xls|',NULL,OPEN_FILE,TRUE);
but it showing me error i.e 'Client_Get_File_Name muse be declare'..
I am unable to open Oracle 9 iSQL window in internet explorer 6. And i have two oracle version installed in my system are 9i and 10g.Now i am able to open the iSQL windows of 10g but not the 9i. It's happen after installing the Oracle 10g in system.
how i open both the iSQL windows in my system the Oracle 9i and 10g
When using this awesome plugin, I have a dynamic action on my calling page that deals with the selection from the dialog.
It uses
Select type:DOM Object
DOM Object: document
Condition: javascript expression
($v('P110_PROD_SEARCH') == 'BLAH')
where the js expression is making sure I run the correct dynamic action, particularly when I have a few buttons on the page invoking different variations of the modal dialog.
My first action is some javascript that interrogates the value of this.data.modalPageCloseValue this facilitates me make decisions in later actions on whether to run some pl/sql, for instance.
potential APEX bug (Display item with HTML affected by dynamic action and since we can't put conditions on actions - I was wondering if I could incorporate something into my dynamic action condition to stop the entire dynamic action from executing if modalPageCloseValue is null - but it seems to be out of scope?
How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies View RelatedI am trying to run PL/SQL Developer from command line, So it can open with an opened SQL WINDOW by default, with a script (which I specify in the command ) already in it:
I've tried:
"C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb
but it just opens the application with a connection, no file.
*CORRECTION* While I was writing this post, I tried something , which is not so sophisticated, and it appeared to work...
C:Program Files (x86)PLSQL Developerplsqldev.exe" userid=andrey/andrey@mydb "C:Program Files (x86)PLSQL Developerandrey.sql"
code for "when button pressed" trigger that will close the current window and displays another window.
View 4 Replies View Relatedi have a html button. With the following attributes: onclick="return false" class="upd_description" A dynamic Action is listening on this button.
Event: Click
Selection-Type: jQuery Selector
JQuery Selector: .upd_description
static_URL: f?p=&APP_ID.:306:&SESSION.::&DEBUG.:306:P306_SER_SK:&P305_SER_SK.
as defined in my button attributes.
Button and dynamic action are on page 305. I can now open Page 306 as modal window but the page will close immediately.
I notified some strange behaviour of my forms debugger. When I insert debug.attach piece of code into ma form and fired them on Windows machine after inserting into Oracle forms builder debugger dialog box server name (usualy ip) and given port from oracle forms window then everything works fine, breakpoint is catched. But when I changed my OS to RedHat then I am not able to come into all kind of trigger form code. Only program units could be debugged.
View 7 Replies View RelatedHow to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.
View 2 Replies View RelatedI am trying to use client_get_file_name to display the select file dialog box. My problem is that I can get the dialog box to open but it does not default to the folder that I specify in the client_get_file_name parameter (r_system_data.import_dir points to c:
eports).
v_filename := client_get_file_name(r_system_data.import_dir, null,
'CSV Files (*.csv)|*.csv|',
'Select a file to import travel details from');
The strange thing is when I use JInitiator 1.3.1.22 the diolog box defaults to the c: eports folder but when I use J2SE JRE 1.5.0_21-b01 it defaults to c: emp (which is where 'My Documents' points to, may be just a coincidence)
I am running Windows XP SP3 with IE8.
how to know when a user was navigating away from the current open form (and I wanted to prevent the navigation with a dialog box) because they had entered a new URL in the address bar and were trying to navigate to it? I've seen a reference to it from an ADF perspective -> [URL]
but was wondering how to do it within Forms?
The reason for this is that i would want to prompt the user to confirm that they wanted to exit the form as potentially they would have a record (in the form) flagged as being updated and as such no other user (including themselves) could susbequently access it. So, I'm basically wanting to know if there is a way to catch the fact that the user is about to navigate to another web page.
Is it by using javascript and if so, how would it be implemented?
How to open a URL from oracle forms ?
Select APP_SERVER_URL into p_url
from CA_EXT_INT_PARAM
where FACILITY_ID =facility_id;
SELECT appl_user_password INTO p_user_password
FROM sm_appl_user
WHERE appl_user_id = P_Login_User;
[code]...
Above coding throws a error unable to open a link..
i am trying to open a .pdf file in oracle forms 10g which had stored in oracle 9i.10g database.
so which method shall i use to do this?
how can i open the .fmx file in oracle 10g?
View 12 Replies View RelatedI would like to open a word document /excel sheet /pdf from oracle forms.
View 20 Replies View Relateddoes the path of office on the server or on the client PC?
View 1 Replies View RelatedI am facing one problem we used to copy any document and for open any document in WINDOWS
Host('CMD /C COPY '||'"'||:Old_Doc||'"'||' X:�3�3'||:New_Doc);
Client_Host('Cmd /C Start '||'X:�3�3'||:New_Doc);
But these commands not running in Linux.
I have installer oracle 11i database, with oracle 10g forms for development.When I am trying to open test form in oracle 10g form only Internet explorer is opening with blank screen, while it is connected to oracle database (version 11i).
Oracle 11i is on windows 2003 ent server and Oracle 10g is on windows 2000 professional...
i want to create a simple form in this form i want to upload the image on the image item with browse button that open a diaglog box that go to the image i select the image and this image is display on image item on the form.
View 1 Replies View RelatedThe 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.
I want to call another canvas in same window.using this code /it not work show_view('canvasname');
View 1 Replies View Relatedi 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 RelatedI 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 RelatedI 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.
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 RelatedI 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 Relatedhow i can set the size of runtime window in My browser? I have a larg form ( 800 X 600 )
View 1 Replies View RelatedI 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.
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.