- 1. No rows returned in Oracle causes SP to fail
- / Oracle PL/SQL /
- ... where rownum/rowcount = 0). Consider the following: SELECT NVL(student_accounts.studentID, 0) INTO v_studentreference FROM ...
- Created on 24 January 2012
- 2. Returning Oracle Stored Procedure Resultset in SSRS
- / SQL Server Reporting Services /
- ... with a closing square bracket (in my example: [@StudentReference]). 4d. Add a dataset: returned "Fields" These is where you "map" the variables to the oracle returned variables. Debug ...
- Created on 19 January 2012
- 3. SSRS Querying on either of 2 Parameters
- / SQL Server Reporting Services /
- ... of this article). The end-user must be able to search on EITHER the student's username or the student's ID (2 report parameters: @StudentADAccount [varchar] and @StudentReference [int] respectively). ...
- Created on 19 July 2011