Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....

Answer Posted / deepak

hi chandu,
this is a sample one

create or replace procedure proc_name(proc_cur in out
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a universe with out using the Designer ??

7003


What is the difference between slice and dice and cross tab report?

818


Difference between zabo and webi?

840


How to create Index to the table in the universe designer and how it improves the Query performence

2320


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1619


Explain what three things do you consider to be the most important factors for a manager?

744


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10298


What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1786


how to create reports on screech?

2254


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2088


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1972


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2601


What is a bo repository?

772


Can you please send me the migration related issues .

1835


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4741