Stored Procedures from Java/VB returning Result Sets(via ADO) 
Author Message
 Stored Procedures from Java/VB returning Result Sets(via ADO)

Database Oracle 7.3.4
Microsodft ODBC for Oracle V 2.573.3711.00
MSORCL32.DLL 01/02/99

In testing a stored procedure(in a package) which returned a result set we
made the following 0bservations.

Calling from Java to Oracle was quick but failed on the 114th iteration of
the call. This was still the case when we tried this on another PC.

Calling from VB to Oracle was significantly slower, but the call worked
every time.

The procedure has an output parameter defined as a pl/sql table for each
column that needs to be returned. Note, that the VB did not bother
displaying any of the Data.

Does anyone know why this behaviour occurs, and more importantly, what to do
to get around the problem.
eg Is there a later driver which fixes the problem?

TIA

Keith



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Returning Multiple Result Sets for Java Stored Procedures

2. AS/400 v4r4 stored procedure is NOT returning result set to VB

3. DB2/400 Stored Procedure w/ADO--return result set

4. returning result sets from stored procedures

5. Returning result sets in oracle stored procedure (OLEDB)

6. return multiple result sets from a stored procedure

7. Can't update result set returned from stored procedure using RDO

8. Returning result set from function to stored procedure is very slooooooooow

9. best way to return a paged result set from a stored procedure

10. Returning a result set from a Stored Procedure

11. returning result sets from stored procedures

12. How not to return multiple result sets from a stored procedure


 
Powered by phpBB® Forum Software