Re: Select Statement in Stored Procedure

From: Jørgen Haukland <jorgen.hauikland_at_fou.telenor.no>
Date: Mon, 26 Oct 1998 15:53:41 +0100
Message-ID: <7122dl$ut@info.telenor.no>

How fortunate !!

I was just about to post a message about the same problem. We're developing an app with MS InterDev against an Oracle8 dB. I'm struggling with the same problems, but I'm now convinced I have to use a stored function in stead of a procedure. In a function You must declare a return type, and here I am stuck. I get all kinds of error messages about wrong declaration when my SQL statements reurn multiple values. I think the package DBMS_SQL may offer the solution but I haveb't figured ut how yet.

I AGREE WITH ALEX; THERE MUST BE A WAY IN ORACLE STORED PROCEDURES/FUNCTIONS TO RETURN RECORDSETS ?? DOES ANYINE HAVE A PL/SQL EXAMPLE ?? -jorgen Received on Mon Oct 26 1998 - 08:53:41 CST