Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yoggi123
Starting Member
29 Posts |
 Posted - 2005-03-14 : 08:20:09
|
| Hi,I am trying to develop a few reports using an Oracle database. I have tried to create some Oracle stored procs, but I am having some trouble getting them to work within the reports. Would it be more advisable to just create SQL stored procs using sql queries and just set the data source to Oracle, or should I be using Oracle stored procs using Oracle sql queries, or does it really matter? I have never used Oracle before in any fashion so my progress is a little slow with the reports.I tried setting the data source to Oracle and just creating procs like I always did, using regular sql syntax and it worked fine, but I am curious about whether I should be doing this or not?Maybe I am going about this all wrong, and what I am thinking might not make any sense, so just let me know that too.Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-14 : 11:19:02
|
| running your queries from the SQL server side could make for performance problems if you are dealing with large datasets. Also, the msdaora driver has not been updated in years and their are some features in oracle that will make the driver completely choke.If you are dealing with small datasets then you might want to look at using the linked server approach. Otherwise I would continue with developing the oracle stored procedures.btw, www.dbforums.com has a forum dedicated to Oracle support, you might check over their for help with your PL/SQL questions.-ec |
 |
|
|
|
|
|
Help using Oracle database