| Calling a Business Objects Report from an Oracle Form. Is it possible [message #85668] |
Mon, 19 July 2004 08:19  |
Roger Simms
Messages: 14
Registered: May 2004
|
Junior Member |
|
|
|
We are running Oracle 8.1.7.0, Forms and Reports 6 and Business Objects version 6 . I would like to know if it is possible to run a business objects report from an Oracle form. At the moment I am just copying the SQL from Business Objects into an Oracle report but it then has to be re-formated. Is there a better way
|
|
|
|
|
|
| Re: Calling a Business Objects Report from an Oracle Form. Is it possible [message #86835 is a reply to message #85670] |
Tue, 09 November 2004 01:31  |
Oladunjoye Oluniyi
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
Hi
It is possible to call Business Object Report from Oracle forms. One way to achieve this is by calling the business object report from the HOST command.
E.g.
declare
BO_path varchar2(200);
My_Report varchar2(30);
Host_Command varchar2(255);
begin
BO_path := 'C:Program FilesBusiness ObjectsBusinessObjects 5.0BUSOBJ.EXE ';
My_Report := 'Stock.rep';
Host_Command := BO_path || My_report;
HOST (Host_Command);
end;
Forms [[32 Bit]] Version 6.0.5.0.2 (Production)
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
Business Object 5.0.3
Windows environment.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
