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