Solved

How to open Excel File from Oracle Forms 10G

Posted on 2009-07-07
3
2,433 Views
Last Modified: 2013-12-19
I want to open an excel sheet from Oracle Forms 10G, I am getting below error
Below is the my Code

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\Office11\EXCEL.EXE c:\files\test.xls',DDE.APP_MODE_NORMAL);
end;

FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-106561

---Any one can help me as this is very urgent for my delivery...

Thanks & Regards
Syed
0
Comment
Question by:Syedhamid
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 24804060
Where is the Excel file (test.xls)?  Is it on the application server or on a client machine?  Since Oracle Forms10 runs as web-enabled application only (and not as a client/server app as earlier versions of Forms did) I'm not sure that Forms10 can use files that exist on a client PC.  It may be limited to working with files that are on the application server.
0
 

Author Comment

by:Syedhamid
ID: 24810116
THanks for Reply

The File is in Application Server, any other method to call exce file from Forms
0
 
LVL 35

Assisted Solution

by:Mark Geerlings
Mark Geerlings earned 500 total points
ID: 24812727
OK, that looks about right to me then.  I've never used the DDE package though in Oracle Forms to open an Excel or Word file.  That always looked to me like more trouble (and more possibilities for problems) than what it might be worth.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question