Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to write a SELECT stored procedure ?

How to write a SELECT stored procedure ?

From: <hari_somaskanthan_at_my-deja.com>
Date: Mon, 02 Aug 1999 13:19:05 GMT
Message-ID: <7o45s0$iqe$1@nnrp1.deja.com> 





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 - 08:19:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US