Recent content by thendrickson

Thanks for the help this is perfect. Sometimes the simplest most basic information is the hardest to find in a goole or Bing search

Thank you very much. This worked perfectly when I ran it using the TOAD application. However, I am not highly skilled using Oracle and am having some trouble using this in a proc. I want to create a proc which returns the parameter list as a refcursor so an application developed in C# (Visual...

Please forgive me for a pretty basic question but I would like to find the way to determine the paramaters of a an Oracle stored proc by querying the system. I believe there was a stored proc or a function that would provide this information for Oracle 10g but I cannot locate the name of the...

Papadba, I found that out I must admit. I underestimated the challenge and over estimated my knowledge a bit [bigsmile]

After additional reading, I was able to determine my problem which was not related to syntax but instead to not having studied db2 enough to understand differences with SQL Server and/or Oeacle on creating procedures

Forgot the first time Version is 9.7

I have little experience with db2 and am trying to create a new procedure by following the example and modifying it to fit my needs I found on IBM's web site I cannnot see the problem with this The first error shows at "Begin" and I have noted the errors shown with the addition of the comment...

After much research, I determined this could not be done or at least not in SSRS 2005

I am using SSRS 2005 to report from an Oracle database. The report is a bit complex to describe, but simply, I have a report that I need to assign a dataset to dynamically. if I can do so. Something like: ReportDataset = Query results. I am processing some data in VB.net code rather than...

Thanks for the help Dagon. I am looking into this now

I am very new with Oracle and am trying to debug legacy procs. The procs are not well designed in my opinion but it is what it is and I need to find out exactly where the errors occur. What I would like to do is figure out a way to add the actual line Oracle fails on and log it along with the...

I am using Crystal 10 and Crystal Enterprise 10 to report from an Oracle 10g database. The report accepts a variable number of input parameters to sort the records returned by an oracle proc. When I attempt to run from Crystal Enterprise, the report is not sorted when the report is formated as...

Thanks. This would count at least as an "oops" I guess :-)

I have reduced a more complex problem to the simplest elements in the following selects. my select using a join does not return any data while the select using a sub select returns data as expected I have researched this forum as well as BOL and am finding nothing that explains where I am...

Well, I have worked a lot with SQL Server, a fair bit with Informix, More Access than I will admit to in public and now Oracle. I contract a lot due to my age and disabilities and mostly I get work that either nobody else wants or they cannot find a qualified person in time. I make a better...