Re: How to write a SELECT stored procedure ?

Hi,

Use cursor.
create or replace procedure GetNames()
begin
open mycursor as
select name from tbemployee;
end ;

hari_somaskanthan_at_my-deja.com wrote:

> Hi,
>
> I am using VB 6.0 to call a stored procedure in Oracle 8x. The
> following stored procedure is written in SQLServer. How do I convert it
> into Oracle stored procedure.
>
> Procedure GetNames ()
> BEGIN
> SELECT NAME FROM TBLEMPLOYEE
> END
>
> This procedure returns a recordset and from my VB program I use client
> side cursor to retrieve all the records one by one.
>
> Thanks
> Hari Somaskanthan
> Hari_S1_at_Yahoo.com
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 10:23:14 CDT