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
I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
I have this pdf (2 Volumes) from Oracle University courses, "Oracle Fusion Middleware 11g: Build Applications with Oracle Forms" In order to read the examples you must have "Summit Office Supply Schema" fmbs, mmb, pll, tables.(dmp)
indicatively some tables (not confuse it with other summit user)
customers,
departments,
warehouses,
orders,
employees,
order_items,
product_information,
inventories
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 RelatedI download a pdf file,but I want to use it in the office word,who knows how to convert it?
View 11 Replies View RelatedI need a query to display the office and count(*)
where rownum > 6 i.e
here is the data
office
------
hq
hq
hq
hq
hq
hq1
hq1
[code]....
I need a query to display the top 3 counts and the 4 row should be sum of count of other offices.
my result should look like this
office count(*)
--------- --------
hq 5
hq1 4
hq2 3
other 10
OS: 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 RelatedI am trying to export data into excel (office 2007 and above- .xlsx) using the calls mentioned below, but i am getting an error. i am able to upload data and open the document in IE succesfully using office 2003 format(.xls)
The following are the calls made in the package and it works for .xls format
OWA_UTIL.MIME_HEADER('application/vnd.ms-excel');
The following are the calls made in the package and it is not working even thow i can see that the document getting opened .xlsx format
OWA_UTIL.MIME_HEADER('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
And i alos added the call in the httpd.conf file in Apache/windows server 2003
AddType application/vnd.openxmlformats .docx .pptx .xlsx
The MS Office 'NETWORK DAYS' function allows you to subtract one date from another and return the number of 'workdays' between them. So it ignores Sat & Sun. There is an additional parameter that allows you to ignore holidays as well.
I'd like to subtract a 'Request Date' from SYSDATE and get just the number of 'workdays'.
How 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
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 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'..
How to Print Customer Copy / Office Copy in rports 6i for example i want to print two copies of any report i want that on first copy of report shows CUSTOMER COPY and second copy of shows OFFICE COPY and report may be on multiple pages.
View 1 Replies View Relatedneed to know how to connect remote database (ie my office oracle database) from my personal laptop. Using TOAD Software. me with the step by step procedure, and what software's I have to download.
View 26 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 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 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?
