Re: Stored Procedure/Package Returning Recordset to C# application.

On 1 Feb 2006 10:32:25 -0800, "LineVoltageHalogen"
<tropicalfruitdrops@xxxxxxxxx> wrote:

>Is a ref cursor in a stored procedure the only way to return a record
>set in Oracle 9i/10g?
>In SQL Server you can simply put "select * from table" in a stored proc
>and you are good to go.  It appears that in Oracle you cannot do this.
>Any input would be greatly appreciated.

 Ref cursors aren't the only way; look up "pipelined table functions" for an
alternative. You can then use the syntax "select * from
table(your_function(whatever))".

-- 
Andy Hassall :: andy@xxxxxxxxxxx :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
.

Relevant Pages

  • Re: .NET & Oracle Ref Cursor
    ... change the SQL statement). ... >> I am creating a service that uses an Oracle backend. ... >> using something that Oracle refers to as a ref cursor. ... >> How does .NET return a stored procedure that uses a ref ...
    (microsoft.public.dotnet.faqs)
  • Re: Can you use the OleDb classes for SQL Server?
    ... No. Oracle uses different syntax, data flow and other methodologies in their ... that uses the OracleClient .NET data provider to access Oracle. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I agree that it would be neat to just call a stored procedure for the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: parameter name problem
    ... stored procedure positionally. ... if you have a proc with two parameters you can call it as: ... > sql server and in oracle it is a simple string, ...
    (microsoft.public.sqlserver.programming)
  • Re: Custom Procedure Replication Error with Oracle Subscriber
    ... The reason we were drawn to the custom procedure is that we have long column ... We are trying to handle the mapping in the custom stored procedure in Oracle ... since there is no way to do this in SQL Server that we could come up with. ...
    (microsoft.public.sqlserver.replication)
  • .NET & Oracle Ref Cursor
    ... I'm creating a .NET service using an Oracle backend. ... stored procedure. ... ref cursor must be declared as part of a package. ...
    (microsoft.public.dotnet.faqs)