adspace


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

Explain about a tricky situation for which you found a very simple solution?

1087


What are the data types present in bo? What happens if we implement view in the designer and report?

1088


explain in detail about type 3?

1097


What sort of existing documents should business analysts refer to when starting on a new project?

1084


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2276


how many reports have u created ? explain a few.

2165


Explain about a time when you discovered a more efficient way to do a work task?

1230


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1206


Explain what is aggregate table and aggregate fact table ... Any examples of both?

1180


What is aggregate table and aggregate fact table ... Any examples of both?

1126


what is document design in boxi,have u participate in that

2315


What is the difference between business requirement document and use case document.

1091


How would you format some text using css to be verdana and bold?

1157


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2177