Stored Procedures and VB

I am new to the oracle world, i have worked with MS SQL Server though.

In MS SQL I would create the following Stored Proc

CREATE PROCEDURE My_info

   @lastname varchar(40),
AS

   SELECT au_lname, au_fname

      FROM authors
      WHERE au_lname = @lastname

Then I just use VB and ADO to execute the stored procedure and put the results in a recordset.

But in oracle, the same does not seem to work. I have some examples of creating oracle stored procedures, but they all declare a cursor and loop through the records.

Also, in the example i have, my VB program needs to tell oracle how many records are going to be returned.

Am i missing the big picture here, or do you really have to: 1. Declare a cursor in all oracle stored procedures, and 2. always tell it how many records will be returned.

Thanks in advance!

• Robbie K -

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 23 1998 - 14:45:57 CDT