Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2542
  • Last Modified:

How to open Excel File from Oracle Forms 10G

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
Syedhamid
Asked:
Syedhamid
  • 2
2 Solutions
 
Mark GeerlingsDatabase AdministratorCommented:
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
 
SyedhamidAuthor Commented:
THanks for Reply

The File is in Application Server, any other method to call exce file from Forms
0
 
Mark GeerlingsDatabase AdministratorCommented:
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now