Problem migrating from SQL Server to Oracle 8i

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 Tue Mar 13 2001 - 21:38:28 CST