Oracle 9.2 Provider Problems

[Joe Chandler]

I am trying to use Oracle 9.2 as the provider in .NET c# and it seems that the simple SQL Maps Work just fine.  When I try to pass a parameter the value does not get substituted.  For example,   <select id="MoveRequestSummaries" resultMap="MoveRequestSummaryResult" parameterClass="MoveRequest">                                        SELECT                             ID,                             STATUS,                             REQUESTER_EMPLOYEE_ID,                             CREATED_BY,                             CREATED,                             MOVE_DATE                      FROM                             MM_OWNER_V8.RQST_MOVE                             WHERE                             STATUS = #Status# </select> Always returns 0 rows or an empty result.   When I switch to the MS Oracle provider and run the same Query Without changing code it returns the expected result.   Here is my provider for oracle:        <provider               name="oracle9.2"               enabled="true"               assemblyName="Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342"               connectionClass="Oracle.DataAccess.Client.OracleConnection"               commandClass="Oracle.DataAccess.Client.OracleCommand"               parameterClass="Oracle.DataAccess.Client.OracleParameter"               parameterDbTypeClass="Oracle.DataAccess.Client.OracleDbType"               parameterDbTypeProperty="Oracle.DataAccess.Client.OracleDbType"               dataAdapterClass="Oracle.DataAccess.Client.OracleDataAdapter"               commandBuilderClass="Oracle.DataAccess.Client.OracleCommandBuilder"               usePositionalParameters = "false"               useParameterPrefixInSql = "true"               useParameterPrefixInParameter = "false"               parameterPrefix=":"        />   Does anyone have any suggestions?   Thanks in advance,   Joe