StoredProcedures & recordsets

From: Stu <stu_at_dkmsoft.com>
Date: Fri, 23 Jul 1999 17:08:35 +0100
Message-ID: <37989383.E4D8B4F6@dkmsoft.com>

I am new to Oracle, but all I am wishing to do is convert some stored procedures from MSSQL6.5.
However, I have hit a problem straight away, I do not seem to be able to get the procedures to behave in the same way. The MSSQL procedures are being called from VC++ and the results are held in a recordset, but with oracle I cannot see how to get them to behave in this way. For example a procedure in MSSQL may say:

CREATE PROCEDURE sp_GetEmp @empid int
as

select * from employess where employerId=@empid return

and this would return a recordset which I can iterate through if more than one value.

Is it possible to do the same thing with Oracle (8) to acheive the same effect. Received on Fri Jul 23 1999 - 11:08:35 CDT