Click here to Skip to main content
11,438,226 members (75,493 online)
Rate this: bad
good
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)



Advertise | Privacy | Mobile
Web04 | 2.8.150506.1 | Last Updated 26 Feb 2013
Copyright © CodeProject, 1999-2015
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