Pls say any one...
how will u create a report using oracle stored procedure?
could u pls send me the step.....
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / reshma
Deepak,
ur answer has helped me a lot.Thanx a tonne. Guys, pls
follow his steps for Creating report using SP:
1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters
Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,
mainly used for returning the CURSOR OUTPUT.
Eg:
CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT
sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
END;
/
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / deepak
u need to create a stored procedure using in/out parameter
of a ref cursor.the parameter of the proc should be in only.
then create a connection to the database using middleware.
suppose u have created a proc on oracle 9i, then make the
connection using oracle client.mention the user
name/password and the data base name in the connection.
then in the report section use the stored procedure as data
provider and select the proc using which you want data ang
generate the report.
deepak
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / chandru
Hi Deepak,
Thanks for giving this information.
if it possible give me a sample stored procedure coding ...
Is This Answer Correct ? | 1 Yes | 0 No |
Difference between b.o 5.1 and 6.1b?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
HOW TO HIDE Column in WEBI & DESKI?
what is local filter
where are objects are stored ?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
What are the major problems will occur while migrating to the one version to another version?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what types of challenges we are faced in creating web i reports .can you please explain with some examples.
What are different types of saving options in web intelligence?