Re: ORACLE 8 & VB5.0 (RDO)

From: Rob Rebmann <rob.rebmann_at_londonlife.com>
Date: 1997/12/11
Message-ID: <01bd0671$ee308430$8e1c65cc_at_ll55049-c1>#1/1

We have successfully execute both Sybase and Oracle stored procedures using VB4/5 using RDO. As for the VB code it is no different. The big difference between Sybase and Oracle stored procdedures is that Sybase supports returning answer sets and Oracle does not. It requires you to return output paramaters.
The way we got around this was to write Oracle stored procedures that wrote the answer set into a work table and then invoked an SQL query from VB4/5 to return the answer set and cleanup after itself.

If you need some clarification I can be reached at rob.rebmann_at_londonlife.com

Manoj Erande <MErande_at_worldnet.att.net> wrote in article <66nqj7$jb0_at_bgtnsc03.worldnet.att.net>...
> Hi,
>
> Recently i finished working on a Sybase System 11 project with VB4.0 and
> am supposed to start work on ORACLE8 & VB5.0 project. Need some help on
> figuring out How do you call "Stored Procedures/Packages" from VB4.0/5.0
> using RDO. Has anyone worked on a similar project.Any Tips, Clues.
>
> Thanx in advance & all help, pointers to information else where , sample
> code is appreciated
>
> Thanx
> Manoj
>
>
Received on Thu Dec 11 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: Mary C. Humphrey: "Drifting Boilerplate Text: Reports 2.5"
Previous message: Johan Andersson: "Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server"
In reply to: Manoj Erande: "ORACLE 8 & VB5.0 (RDO)"
In reply to Manoj Erande: "ORACLE 8 & VB5.0 (RDO)"
Next in thread: Hoff Hoffman: "Re: Oracle7 Support on OpenVMS VAX (was Re: Oracle and Digital drop Support of VAX/VMS post 1999.)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message