[DB-SIG] How to return results from stored procedures in Oracle

Marcos Sánchez Provencio msanchez@grupoburke.com
31 Aug 2002 12:40:22 +0200

Hello there.

In TSQL (the procedural language used in Sybase and MSSQL) it is very
simple to return rows from a procedure and use it as a query issued by
the user dinamically. I have managed to do get the same effect in ADO/VB
using a rather contrived mechanism which involved putting the procedure
in a package and returning some type (cursor, I think).

How can I get it using DBAPI in Oracle? How about PostgreSQL?

What I want is something like

--TSQL code--

create procedure onlyone @id int
select * from mytable where id=@id

--END TSQL code--

So, for example, I can give permissions to access the data one by one,
knowing the id in advance.