Problem with oledbcommand paramaters

[nzcam]

Hi, I have created a oledb connection / command that connects to a oracle 7.3 database .

the oledbCommand was set up in designer that executes a oracle stored procedure with 2 input paramaters with default values.

This all works ok when I pass in the 1st paramater ,but when I try to pass in the second parameter I get exceptions.

Can anyone help me with this problem , It is probably something stupid.

My code is as follows

in designer

olddbCommand (cmdTLRD) set up with paramaters collection - 2 inputs (0 and 1) set up as integer size 9.

In the click event of button

Dim result As Integer
Dim drtlrd As OleDbDataReader

cnTLRD.Open() 'olddbconnection

cmdTLRD.Parameters.Item(0).Value() = ln_start
'cmdTLRD.Parameters.Item(1).Value() = ln_end

(when this line is uncommented exceptions occur)

result = cmdtlrd.ExecuteNonQuery() ' Fails here when 2nd parameter is uncommented.


Thanks

 

[jmcilhinney]

Assume we know nothing about what you are doing, which we don't. What is the exception that you get and what does your SP look like?