After just typing the spMyProc, I received the following error. The 3
parameters are inside the oracle stored procedure... I had included them also
in the Parameters' tab.
Report item expressions can only refer to fields within the current data
set scope or, if inside an aggregate, the specified data set scope.
Build complete -- 3 errors, 0 warnings
Why is that?
[quoted text, click to view] "Alain Quesnel" wrote:
> Are you running the MSSQL stored proc or the Oracle one? With a MSSQL 2005
> sp, just put spMyProc in the query editor in Business Intelligence Studio.
> Then configure the parameters using the Edit Dataset window and the
> parameters tab.
>
> --
>
> Alain Quesnel
> alainsansspam@logiquel.com
>
>
www.logiquel.com >
>
> "greatdane" <greatdane@discussions.microsoft.com> wrote in message
> news:13C68CDD-C7FC-4B18-BCA4-F8F23AD99AA1@microsoft.com...
> >I have an oracle stored procedure that will accept 3 parameters from a
> >report
> > services..... it seems that I can not find the way to call this stored
> > procedure since the syntax is not the same as this sp was written in SQL
> > Server.
> >
> > Could you help?
> > Thanks
>
Are you running the MSSQL stored proc or the Oracle one? With a MSSQL 2005
sp, just put spMyProc in the query editor in Business Intelligence Studio.
Then configure the parameters using the Edit Dataset window and the
parameters tab.
--
Alain Quesnel
alainsansspam@logiquel.com
www.logiquel.com [quoted text, click to view] "greatdane" <greatdane@discussions.microsoft.com> wrote in message
news:13C68CDD-C7FC-4B18-BCA4-F8F23AD99AA1@microsoft.com...
>I have an oracle stored procedure that will accept 3 parameters from a
>report
> services..... it seems that I can not find the way to call this stored
> procedure since the syntax is not the same as this sp was written in SQL
> Server.
>
> Could you help?
> Thanks
Don't see what you're looking for? Try a search.
