Cathi,

How can you trace code when it will not compile?

Thanks

Rex

>Have you tried tracing this code? See if the variable is getting created and what the state of it is when you get to the Try block.
>
>>Cathi,
>>
>>I have the following code:
>>
>>

>>Sub btn_chgpwd(ByVal s As Object, ByVal e As EventArgs)
>>	If IsValid Then
>>		myConnection = New OracleConnection(odh)
>>		myConnection.Open()
>>		myTrans = myConnection.BeginTransaction()
>>		myCommand = myConnection.CreateCommand()
>>		With myCommand
>>			.CommandText = "pkg_users.UPDATE_USERS_QUESTION"
>>			.CommandType = CommandType.StoredProcedure
>>			.Transaction = myTrans
>>			Dim P_USER_ID, P_USER_QUESTION, P_ANSWER, P_MODIFIED_BY, P_ERROR_ID, P_ERROR_MSG As OracleParameter
>>			With .Parameters
>>				P_USER_ID = .Add("@P_USER_ID", OracleType.VarChar, 10)
>>				P_USER_ID.Value = Session("UserName")
>>
>>				P_USER_QUESTION = .Add("@P_USER_QUESTION", OracleType.VarChar, 120)
>>				P_USER_QUESTION.Value = txtnewpassword.Text
>>
>>				P_ANSWER = .Add("@P_ANSWER", OracleType.VarChar, 60)
>>				P_ANSWER.Value = txtrenewpassword.Text
>>
>>				P_MODIFIED_BY = .Add("@P_MODIFIED_BY", OracleType.VarChar, 10)
>>				P_MODIFIED_BY.Value = Session("UserName")
>>
>>				P_ERROR_ID = .Add("@P_ERROR_ID", OracleType.Double)
>>				P_ERROR_ID.Direction = ParameterDirection.Output
>>
>>				P_ERROR_MSG = .Add("@P_ERROR_MSG", OracleType.VarChar, 100)
>>				P_ERROR_MSG.Direction = ParameterDirection.Output
>>			End With
>>		End With
>>
>>		Try
>>			myCommand.ExecuteNonQuery()
>>
>>			If P_ERROR_ID.Value = 0 Then
>>				Response.Write("before commit")
>>				myTrans.Commit()
>>				myConnection.Close()
>>				Response.Redirect("/login/menu.aspx")
>>			Else
>>				myTrans.Commit()
>>				myConnection.Close()
>>			End If
>>		Catch eex As Exception
>>			Response.Write(eex.ToString())
>>			myTrans.Rollback()
>>			myConnection.Close()
>>		End Try
>>	End If
>>End Sub
>>
>>

>>
>>In the TRY block above, the P_ERROR_ID.Value line give the following error:
>>
>> Name 'P_ERROR_ID' is not declared.
>>
>>and all this procedure is under the IF statement. If I move the DIM statement outside the loop, no error occurs.
>>
>>Is there another way to do this?
>>
>>
>>Thanks
>>
>>Rex
>>
>>
>>
>>
>>>Hi Rex,
>>>
>>>I would recommend tracing through this code in the debugger and see if ConPubs is ever created in the If statement.
>>>
>>>>All,
>>>>
>>>>I have a codebehind file that I want to be able to use either the OleDb or Oracle data providers. I have created a strProvider variable and use If statements to dimension Connections, Commands, etc for both Oracle and Oledb. After dimensioning the objects, I try to open the connection outside the if statement, since the connection object is created by that time, but the compiler says the object is undefined.
>>>>
>>>>

>>>>Dim strProvider As String = "OracleClient"
>>>>
>>>>If strProvider = "OracleClient"
>>>>	Dim ConPubs As New OracleConnection(odh)
>>>>Else
>>>>	Dim ConPubs As New OleDbConnection(odh)
>>>>End If
>>>>
>>>>ConPubs.Open()
>>>>

>>>>
>>>>Is there a way to set this so I can conditionally create an object and use them?
>>>>
>>>>Thanks
>>>>
>>>>Rex