Thread: SSRS Oracle Cursor debacle
10-04-11, 10:41 #1Registered User
- Join Date
- Oct 2011
Unanswered: SSRS Oracle Cursor debacle
hey guys need some brainstorming help here. we're using SSRS rpts against an oracle database using views as the datasource. we have the need to use dynamic queries. well, the normal thing for me is a ref Cursor i.e.:
using a proc and a dynamic querystring.
procedure Proc_Inv_Standard_Format(WhereClause varchar2,c_a1 OUT t_cursor)
v_strSQL := 'Select * from vw_rpt_inv_standard_format Where ' || WhereClause;
open c_a1 FOR v_strSQL;
the problem is, SSRS cannot see an object.
now if i make it like this:
v_strSQL := Select * from vw_rpt_inv_standard_format;
no problem, but i return 1/2 of the dang database which defeats having the where clause.
i need a way around this.
would it maybe be possible to have two ref cursors, the 2nd one being the one that's dynamic & then just assign that to the first one which will be returned?
this seems to be a major flaw in SSRS itself that it can't do this. any ideas are appreciated.
10-04-11, 11:27 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>any ideas are appreciated.
We don't have your tables, data or requirements.
Based upon non-existent posted details, I could not identify a correct answer, if one were posted.
>the problem is, SSRS cannot see an object.
what does above line mean & why does it matter?You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.