iceicebaby
Programmer
I am using CR 8.5 and Oracle 8. My Report is based on a stored procedure and it doesn't get the fields when I try to create it. Earlier, I've created many Reports based on Stored Procedures and they all work fine. Can't figure out the problem.Any Help is highly appreciated.
I'm just giving the relevant section of my Stored Proc below:
I'm just giving the relevant section of my Stored Proc below:
Code:
Create Or Replace procedure prod_mgmt5(Test_Cursor IN OUT Test_Package.Test_Type,Monthno IN Number,YearNo IN Number,prod_type_gp IN Varchar2) AS
Cursor Ban_cursor(MBU1 in Varchar2,MBU2 in Varchar2,MBU3 in Varchar2,MBU4 in Varchar2,MBU5 in Varchar2,MBU6 in Varchar2) is
Select ban
From Cust_Data_Crossref
Where Data_value IN (MBU1,MBU2,MBU3,MBU4,MBU5,MBU6)
and Item_type = 'MBU';
Ban_Val Ban_cursor%RowType;
Begin
For Ban_Val in Ban_cursor(MBU1_val,MBU2_val,MBU3_val,MBU4_val,MBU5_val,MBU6_val)
Loop
--Assign values
End Loop
For i in 1..22 loop
Insert Into pmr5_Tab Values(Unitst(i),Revenuet(i));
End Loop;
Commit;
Open Test_Cursor For
Select * From pmr5_Tab;
End;