Oracle stored procedures and VB applications [message #4366] |
Tue, 03 December 2002 04:05 |
David Pennick
Messages: 1 Registered: December 2002
|
Junior Member |
|
|
We are currently trying to move an application from a Sybase back end to an Oracle back end, we are also trying to do this as cheaply as possible by trying to avoid massive rewrites to the application. In sybase we were able to write a stored procedure so the last statement was SELECT * FROM
WHERE <condition> but it would appear that we cant do this is Oracle and that we need to use record sets to pass the data from the database to the application. Is this correct? Is there anyway we can get around using record sets and exploit the technique we use at the moment??
Thank you for your time
Dave
|
|
|
|