Forms :: Open New Excel Application From 10g?
May 6, 2008How can i open a new Excel application from Forms 10g?
View 2 Replies
ADVERTISEMENT
Forms :: Open Excel Sheet From PL/SQL Program
Jul 13, 2010I 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]....
Forms :: Open Word Document / Excel / PDF From Oracle?
Mar 25, 2008I would like to open a word document /excel sheet /pdf from oracle forms.
View 20 Replies View RelatedForms :: Open Word Document / Excel And PDF From Oracle?
Apr 29, 2010does the path of office on the server or on the client PC?
View 1 Replies View RelatedForms :: Uploading From Excel Stop When Open File?
Oct 21, 2010I'm uploading data from excel to our database using forms thru webutil. The problem is when I open the same excel file while the upload process is in progress, the uploading stops, BUT not displaying any error. Not even when I chick Help->Show error.
How could I prevent this error and how to trap and display error message?
Forms :: Open Application Word 2010 With Forms Developer 6.0 - Windows 7?
Apr 20, 2011I 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 RelatedSQL & PL/SQL :: Excel File Can't Open
Aug 17, 2010im sending email with attachment of report output in xml format. file was attached but cant opened.
it show me error at the time of opening that
XML ERROR in Unknown
REASON: Illegal Tag
FILE: C:Documents and SettingsTxisDesktopAR_AGING_DETAILS_1186958_1(3).XML
VALUE: ?B/to{??C
i face this problem when i send mail on yahoo and from outlook. but it opened in gmail, from incredimail
Forms :: Screen Not Open - Application Stuck
Jul 6, 2013I 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 RelatedOpen Excel File From Oracle Directory On Local Machine
May 31, 2013I have an application where I generate a excel using data in a table and write excel file in oracle directory.Now my requirement is to open that file from local machine .How can i achieve it.I am using Apex 4.2,Oracle 10g .
View 1 Replies View RelatedForms :: Make Excel Dump For Some Banking Application Using 6i?
Jun 17, 2010I am trying to make an excel dump for some banking application using Forms 6i . I am making use of OLE to make an excel dump. I have a small problem while using this OLE concept . I have an Account column which is is having the data type VARCHAR2 at database level . when i try to make a excel dump of this column , then the values in the account number column in excel is getting converted into number column . Eg: A/c - 000123 is appearing as 123 in excel. How this can be retained as 000123 in excel sheet .
test case -
actual value appearing value in excel
000123 123
code extract in hv used -
args := ole2.create_arglist;
ole2.add_arg(args, rowcount);
ole2.add_arg(args, colcount);
cell := ole2.get_obj_property(worksheet, 'Cells', args);
ole2.destroy_arglist(args);
ole2.set_property(cell, 'Value', rec1.BANKNR);
ole2.release_obj(cell);
Reports & Discoverer :: Unable To Open Report In Microsoft Office Excel Format
Jul 6, 2010I 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.
Real Application Clusters :: Unable To Open Wallet / ORA-28353 / Failed To Open Wallet
Jul 11, 2012I want to create a wallet on RAC setup.I have two node setup.I have created the wallet directory under shared folder /u01/oradata/$ORACLE_SID/wallet
I am Unable to open wallet.I tried this using the below command
SQL> alter system set encryption key identified by "aryabhat";
alter system set encryption key identified by "aryabhat"
*
ERROR at line 1:
ORA-28353: failed to open wallet
Following is the content of sqlnet.ora file
(path : /u01/app/11.2.0/grid/network/admin/sqlnet.ora)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /u01/app/oracle
ENCRYPTION_WALLET_LOCATION =
(SOURCE = (METHOD = FILE)(METHOD_DATA =
(DIRECTORY = /u01/oradata/$ORACLE_SID/wallet/)))
Application Express :: Open RTP Report By Pressing Button
Aug 27, 2012Is this possible to open rtp report(oracle report), by pressing button in apex.
View 2 Replies View RelatedApplication Express :: Open Download File In New Window?
Jun 5, 2013How to make an item as a mandatory field dynamically with the change of another item in different regions
View 8 Replies View RelatedApplication Express :: Open Lists In New Tabs / Pages?
Jun 5, 2013We have created a lists (shared objects) with a couple of links which is displayed on all application pages. It is easy to maintain. My question is that the links open in the same page. I was hoping we could use something like a "Target=_New"..I guess the only other way would be to manually code this as a HTML region in each page using <a href> as the last resort!
View 3 Replies View RelatedApplication Express :: Skillbuilders Modal Page - End Open Event?
Apr 24, 2013I'm using Skillbuilders Modal Page 2.0.0. plugin on Apex 4.2, and I can't seem to get the event End Open to work. stumbled upon this thread Skillbuilder Modal Page - Dynamic Title; nothing happens even if I set an alert to pop up on End Open
View 7 Replies View RelatedApplication Express :: Cannot Open Login Page - Not Able To Get Parameters Values
Nov 20, 2012Not able to open login page 101 in my internal application. I am getting below error
ORA-12170: TNS:Connect timeout occurred
Error Not able to get parameters values
OK
Session Restriction - Limit Number Of Open Application Actions By Some Os User?
Sep 17, 2013,in 11g,is there a way I could limit the number of open application actions by some os user ?We have an application where users are executing the same thing while the last is not yet finished,so we have several same things runninng at the same time executed by the same user.
Can we restrict that somehow through the database or that needs to be done through application?
SQL & PL/SQL :: ORA-01000 Maximum Open Cursors Exceeded Frequently While Running Application In Java
Jun 23, 2011I am working on SQL,PLSQL and my application is in Java. I have 2 schemas in same database.
In one schema, the DML operations are very slow while in other schema is fine.
Also I am getting an error ORA-01000 maximum open cursors exceeded frequently while running application in Java.
Application Express :: Upload From Excel For Several Tables
Jan 7, 2013Pretty new to APEX and was hoping to accomplish with native functionality.
Using the latest APEX, there is nice functionality that creates a wizard for you for a single table. I wanted to have a single wizard but pick a table then have the ability to map my fields for insert/update.
Forms :: How To Open Multiple Forms Selecting At Once
Apr 26, 2011OS: 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
Forms :: Open 6i In 11g?
Oct 13, 2012I install Forms 11 g . how i an use my Old Fmb files ? (my forms designed in forms6 i )
View 2 Replies View RelatedForms :: Export Forms Data Into Excel Sheet - Client-ole2 Not Working?
May 28, 2010I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
View 7 Replies View RelatedForms :: How To Open PDF Files Using 6i
Feb 17, 2006How 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
Forms :: How To Open URL From Oracle
Mar 14, 2012How 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..
Forms :: Open PDF Files
Jan 4, 2011I have a PDF files in my file Server, i want to open it through Forms 10g .
View 9 Replies View RelatedForms :: Open Dialog Box On From
Feb 19, 2013i 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'..
Forms :: Map Excel Columns On Oracle Forms And Insert It Into Database
Apr 12, 2013I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
Application Express :: Configure In Order To Download A Report With Excel
Apr 9, 2013In my xe installation, what should i have to configure in order to download a report with excel. not with csv.
View 2 Replies View RelatedForms :: DDE Package With Open Office?
Jul 10, 2011I 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 Related