Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to return a result set in PL/SQL

Re: How to return a result set in PL/SQL

From: Klaus Zeuch <KZeuchnospam_at_hotmail.com>
Date: Thu, 9 Nov 2000 17:25:59 +0100
Message-ID: <8uelth$6og$1@papyrus.erlm.siemens.de>

It can be achieved with ref cursors. For details see http://osi.oracle.com/~tkyte/ResultSets/index.html (please be patient, it's not the fastest site, but one of the best concerning Oracle items)

Klaus
Ian Carrick <ian_at_rombus.co.uk> schrieb in im Newsbeitrag: 973780968.29219.0.nnrp-12.c2de47d8_at_news.demon.co.uk...
> I'm quite new to PL/SQL in Oracle 8i having been used to SQL Server 7
 T-SQL.
> I was used to just entering an SQL statement such as:-
>
>
> SELECT * FROM VAT
>
> into a stored procedure in SQL Server 7 and calling it by using 'exec
> usp_GetVAT'. What are the best methods to do the same in Oracle 8i? I
 know
> I need to set up some sort of cursor/package but how exactly do I do it
 and
> how do I send the data back if the stored procedure is called from SQL
 Plus
> for example.
>
> Help is appreciated.
>
>
>
>
Received on Thu Nov 09 2000 - 10:25:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US