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 want to open dialog window using oracle forms 10g on button click event.
View 3 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 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 RelatedOS: WinXP
Developer Suite 10g Rel.2
its a very basic query, i want to open multiple .fmb / .rdf files at once ( like pressing Shift or Ctrl key when selecting multiple files ), but its not allowing me
I install Forms 11 g . how i an use my Old Fmb files ? (my forms designed in forms6 i )
View 2 Replies View RelatedHow can I open any pdf(Acrobat Reader) file thru Oracle Forms 6i through procedure. I have written procedure to open .Doc & .XLS files by using OLE2.Create_Object but unable to do for .PDF files.
I m attaching the code in txt file , how i have done it for word
open_word is the name of the procedure/program unit
I have a PDF files in my file Server, i want to open it through Forms 10g .
View 9 Replies View Relatedi 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 trying to read/write Open Office scalc.exe(which is replacement of Excel file) file using DDE Package as like Excel File. But it is giving me non oracle Exception Error when it focused or initiate.
View 2 Replies View RelatedI have a folder "c:Images" which has around 5 image files they all are Tiff Images. now from forms i want to open this images one by one.
example:
file 1: SIGN.TIFF
file 2: FORM.TIFF
file 3: FORM_1.TIFF
File 4: FORM_2.TIFF
File 5: PHOTO.TIFF
I have the form and in that I have only one Image Item and two buttons with name "Previous" & "Next"
Action to be Done:
-> Initially when i start form SIGN.TIFF has to open.
-> when i press next FORM.TIFF has to be replaced with SIGN.TIFF
so on...
Note: There is a chance of keeping 10 more files.
How can this be achieved in forms.
How can i open a new Excel application from Forms 10g?
View 2 Replies View Relatedi have fmx file and i want to open it in any text editor
View 7 Replies View RelatedI working in windows environment and using form 6i. Everyone have used the same form and they are getting properly. But when i run the same form i am getting the following error.
PDE-DFF003: Can't Open Library : D2KWUT32.DLL
I am getting the above error when i execute the following line on when - button - pressed
w_user := Win_Api_Environment.Get_Windows_username(False)
When I am trying to open a PLL[5i] through Form5i Builder , Getting Error message like "FRM-10043 Cannot open a File".
View 1 Replies View Relatedi have one word doc file name is sample.doc
i have 3 buttons in my canvas. 1st button is to open a word document.
codings:
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('D:Program FilesMicrosoft OfficeOffice12winword.exe F:DevSuiteHome_1formssamples.doc',DDE.APP_MODE_NORMAL);
end;
2nd button:
i want to delete the existing sample.doc file via forms
i dont know the codings.
I need to open an excel sheet from PL/SQL program where I will put in the data. How to open an excel sheet from Pl/sql code.I got hold of a code as below Looks like I need to configure DAD PL/SQL
BEGIN
-- Prepare Headers
owa_util.mime_header('application/vnd.ms-excel',FALSE);
--htp.p('Content-Length: '||document_length||NL_CHAR);
--htp.p('Content-Length: '||document_length);
[Code]....
I have One .FMB Screen and in this Screen One Table , I Compile and attach in ERP System but when I tried to open thst screen is not open and also application is stucking.
View 1 Replies View Relatedis it possible to create a button can open directory like My Documents
i test this in CMD command prompte it's work but in forms they are not work
"explorer.exe" & @MyDocumentsDir
or
cmd /c "explorer.exe" & @MyDocumentsDir
in forms : i create a button with trigger When-button-pressed
my host('"explorer.exe" & @MyDocumentsDir');
host ('cmd /c "explorer.exe" & @MyDocumentsDir');
but it's not work
I want to use dialog for selecting file in Fomrs 6i.I attached d2kwutill.pll into form, i uploaded d2kwut60.dll into <ORA_HOME>/bin and coded WIN_API_DIALOG.OPEN_FILE to open file. Everything works fine on the machine I'm developing, the open file dialog works and it returns file name. But when i upload form on remote machine where i access through the web it won't work.
I uploaded d2kwutil.plx on remote machine to the directory where forms reside. This is when I attach library without storing full path of it which is in my case c:someFormsDir - note! on remote machine Forms reside on d:Forms, and on local machine I have only c: HDD D: is cdrom and i can't change drive letters.
I also try to upload d2kwutil.plx in c:someFomrsDir on remote machine although forms there reside in d:Forms, but on local machine library(and forms) reside in c:someFormsDir.
None of two above examples work.
I upload d2kwut60.dll in <ORACLE_HOME>in direcotry - doesn't work. I even upload d2kwut60.dll in orahome2in direcory, doesn't work. On my local machine d2kwut60.dll is in ORA_HOMEin where ifsrv60.exe can be found, the same i do on remote.
When I puch button to open dialog for choosing file Internet Explorer freezes.
i was create simple two forms in the first forms i want to create a hyperlink that open another forms.
View 1 Replies View RelatedI've a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf',DDE.APP_MODE_NORMAL);
end;
The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?
I am using forms 10.1.2.0.
I am try to open one .fmb file but file is not open in form builder.Its shows message "cannot open file".
I am going to help button its told that fmb in not create in that form builder. but that fmb is made in 10g but now is not open.
one of my friend created a form in his PC(which is having the same configuration as my PC) and sent me that .fmb file. when I'm opening that form, it is throwing "FRM-11009 : Failed to load in the color palette" error..
I have checked the CAUPREFS.ORA where Forms.color_mode = 1 and I haven't found 'forms.color_pallete' entry in that file.
In Oracle Form runtime, I Open Form A, Form B, Form C, ... how to code get all open forms (A, B, C,...)?
View 7 Replies View Related