I didn't realize your error was at compile time. I thought you were referring to runtime. You should Dim you variables outside of the If clause. The compiler can't guarantee that the Dim statement will execute before a reference is made to it. It is good practice to Dim you statements at the top of your function and then use them as needed throughout.

>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