You need to use a ref cursor. A simple scan of this newsgroup of or the
documentation should yield a lot of examples. also www.technet.oracle.com
or the Ask Tom web site witha link off the Oracle mag web site.
Jim
"Jon" <jleather_at_adelphia.net> wrote in message
news:UIBr6.27648$St6.17998727_at_news2.news.adelphia.net...
> I'm currently migrating a database from a SQL server to Oracle (and I am a
> newbie to Oracle). The database is used by an thin client VB app which
> expects recordsets returned from the database when it calls a stored
> procedures. However, I've come across a problem i cant seem to find a
> solution to. Stored procedures in oracle do not seem to be able to return
> recordsets... simple example
>
> in SQL server (Transact-SQL):
>
> create or replace procedure sp_test
> (
> @cid int
> )
> AS
>
> select * from CITIES where CityId = @CID;
>
>
>
> however the following in PL/SQL generates error cause its expecting an
into
>
>
> create or replace procedure sp_test (CID in CITIES.CityId%TYPE) is
>
> select * from CITIES where CityId = CID;
>
> end sp_test;
>
>
>
> Can someone give me some help on how to return complete recordsets?
>
> Thanks.
>
>
>
Received on Sat Mar 17 2001 - 10:19:01 CST
