Click here to Skip to main content
12,064,546 members (54,284 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: C# Oracle
Hi,
I'm trying to create an rdlc report using oracle 11g. But in rdlc report datasource generation only tables and views are shown, stored procedures are not shown. But I want to use procedures. How can I do that. Please anybody help me out. Thanks in advance.
Posted 26-Feb-13 1:43am

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

But in rdlc report datasource generation only tables and views are shown, stored procedures are not shown.
StoredProcedure does not store data information and thus they are not shown along with Tables and Views. SP's are queries on a high level and thus, you can use SP's as a query to fetch data in your report.

Further, SP's will fetch specific data based on certain conditions where as Tables/Views are to store/collate all the data irrespective of specific criteria.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160204.4 | Last Updated 26 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100