PASS recordset BACK to the Oracle SP 
Author Message
 PASS recordset BACK to the Oracle SP

Hi All,

As you may know there is an article
Q176086 - HOWTO: Retrieve Recordsets From Oracle Stored Procs Using ADO

However I need do it in reverse. Is there a limit of number of records in
Oracle 's TABLE TYPE?
How would I do that?

Thanks,
Alex.



Sun, 30 Nov 2003 04:11:40 GMT  
 PASS recordset BACK to the Oracle SP
Alex,

You cannot do this directly with Recordset. You can workaround it as
follows.

1. Use separate parameters instead of an array of parameters;
2. Pack the parameters into a comma-delimited string, which will be parsed
in the stored procedure.

Peter



Tue, 02 Dec 2003 14:36:31 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. passing recordsets to oracle SP

2. Passing user defined data type as input to ORACLE SP

3. recordset from Oracle sp w/ ADO

4. pass parameter to SQL SP from VB and return recordset

5. stored procedures passing back Oracle blobs to ADO

6. Using ASP to navigate back and forth in Oracle recordset

7. Passing recordset back from function

8. Passing recordset back from function

9. passing recordset back to ASP from a COM-object

10. Passing recordset back from function

11. Ado recordsets-passing back from function

12. Passing recordset back from function

 

 
Powered by phpBB® Forum Software