Re: Oracle Procedure Question- Please.
From: Gary Gapinski <gapinski_at_lerc.nasa.gov>
Date: 1995/04/20
Message-ID: <3n68fa$hi8_at_sulawesi.lerc.nasa.gov>#1/1
Date: 1995/04/20
Message-ID: <3n68fa$hi8_at_sulawesi.lerc.nasa.gov>#1/1
Oracle stored procedures do not return result sets. They can at best return a cursor to a result set. I know of no workaround other than to use views wherever possible. If you do not need to have procedural results manifest as a result set, look into the DBMS_OUTPUT package, although that will not be of much use to an application that expects results to be prepared as if they had been SELECTed. Also, in recent releases, user-declared functions can be cited in SELECT statements.
Using temporary tables will probably be more of a bother than it's worth. Received on Thu Apr 20 1995 - 00:00:00 CEST