Oracle 9.2 Problems

Thu, 27 Jan 2005 13:32:33 -0800

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

 

 

 

Reply via email to