Re: Reporting with dynamic sql ... In Oracle you *don't* need temporary tables. ... What you need is a REF CURSOR....variable cur REF CURSOR...Sybrand Bakker, Senior Oracle DBA ... (comp.databases.oracle.misc)
Re: newbie passing parameters from Web page to Stored Procedure ... I think it is in my First SQL statement.... I'm using Oracle 9i. ... CREATE OR REPLACE PACKAGE pkgpending AS ... What you likely want to do is return a REF CURSOR.... (comp.databases.oracle.server)
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: passing in list of values in stored procedure ... modified the procedure here to use REF CURSOR - applicable in Oracle... not just lists as is evident from this example. ... back to .net programs and jdbc programs. ... (comp.databases.oracle.server)
Re: ODP.NET Ref Cursor Input to oracle Stored Procedure ... he adds a second parameter for the input REF_CURSOR. ... I want to send an Input Ref Cursor from .NET to Oracle.... My webservice has the data in xml format with multiple records. ... (microsoft.public.dotnet.framework.adonet)
