Home Forums SQL Server 2008 Working with Oracle Passing an argument to an Oracle Stored Procedure and returning a record set to SSRS 2008 R2 RE: Passing an argument to an Oracle Stored Procedure and returning a record set to SSRS 2008 R2

  • Hi, any people.

    here two solution:

    Frist: qualify the store pocedure in SSRS.

    Second: Create synonym (private or public) of store procedure in account or scheme that it is configuration in the datasourse of SSRS.

    My recomendation is create synonym private.

    Regards,

    your server