Re: Stored Procedures and VB

Hi:

Try using ORACLE Objects for OLE rather than ODBC.

Good luck,

--

David C. Sisk
http://www.ipass.net/~davesisk/ORACLEonNT.htm

rjkdev_at_rocketmail.com wrote in message <70qmdm$vc$1_at_nnrp1.dejanews.com>...
>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 Sun Oct 25 1998 - 20:23:20 CST