Search results for query: *

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...

Thank you very much!!!. the ":" seems to be the piece I was missing. I am suprised that I never turned that up in any of my Bing and Google Searches I can now take it from here. Thanks to everybody for the effort. And I apoligize for such a very basic question

As I said, I am really new at Oracle so here goes: In your example where you show "SQL> exec OracleProc Input1, input2(:cur1);" What does the : mean? I have heard of SQL plus but I do not have it installed.

LKBrwnDBA Exactly!!!! I have yet to figure out how to call this from Oracle much less the OPENQuery function of SQL. Thanks TurkBear: "Oracle REF CURSOR can have many records." As does a SQL Server recordset But thanks for the input

I still must not be communicating. What I do not know and cannot seem to find is how to call an Oracle proc that returns a cursor as an output parameter. Even when calling the proc from another Oracle Proc. If I understand Oracle at all (and I may not), Oracle returns explicitly defined...

I am afraid I must have terrible communication skills so please bear with me. What I intend to do is to execute an existinf oracle proc and use the results. The OpenQuery function is a "pass through query" that would execute on the Oracle box. Your suggestion worked for me in the past for...