Limit to input parameters?

[HezMac]

Hi

I'm wondering if anyone knows if there is a limit to the number of parameters I can send from VB6 (using adParamInput) to a stored procedure in PL/SQL.

I'm trying to send 11 input parameters into the stored proc. When I do this, the procedure doesn't work. When I commented out 2, it works!

Testing the script in PL/SQL, I know it works, so I figure it must be I'm sending too many input parameters.

Does anyone know how to reset the number I'm allowed to send or another way to get around this?

Thanks for any advice.

 

[tazuk]

Presuming that you are using the ADO Command object to run the stored procedure, and appending the parameters IMHO 11 should present no problem. I have one (SQL Server) stored procedure that requires 85 input and 1 output parameters that I execute in this manner from VB without any issues.

HTH

TazUk

Blue-screening PCs since 1998

 

[fredericofonseca]

If it works when you comment out two then the definition of one of the second last is wrong.

To be sure about this try and comment all parameters, and then use one at the time until you find the wrong one.
Note that not all PL/SQL definitions are available with ADO.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com