StoredProcedures & recordsets
From: Stu <stu_at_dkmsoft.com>
Date: 1999/07/23
Message-ID: <37989383.E4D8B4F6_at_dkmsoft.com>#1/1
Date: 1999/07/23
Message-ID: <37989383.E4D8B4F6_at_dkmsoft.com>#1/1
I am new to Oracle, but all I am wishing to do is convert some stored
procedures from MSSQL6.5.
CREATE PROCEDURE sp_GetEmp _at_empid int
as
select * from employess where employerId=_at_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.
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: