Home » SQL & PL/SQL » SQL & PL/SQL » Oracle stored procedures and VB applications
Oracle stored procedures and VB applications [message #4366] Tue, 03 December 2002 04:05 Go to next message
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
Re: Oracle stored procedures and VB applications [message #4374 is a reply to message #4366] Tue, 03 December 2002 11:39 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You would use a REF CURSOR output parameter to pass the result set back to VB. See here for details:

Previous Topic: Deleted records stored in a Table?
Next Topic: Records written into destination table gets reordered somehow
Goto Forum:
  


Current Time: Wed May 15 03:55:41 CDT 2024