Click here to Skip to main content
Sign Up to vote bad
good
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 0:43am


1 solution

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
Your Filters
Interested
Ignored
     
0 Christian Graus 544
1 Ron Beyer 296
2 OriginalGriff 258
3 samadhan_kshirsagar 229
4 Sergey Alexandrovich Kryukov 183
0 Sergey Alexandrovich Kryukov 7,007
1 Prasad_Kulkarni 3,815
2 OriginalGriff 3,557
3 _Amy 3,372
4 CPallini 2,975


Advertise | Privacy | Mobile
Web03 | 2.6.130617.1 | Last Updated 26 Feb 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid