Oracle 9.2 Provider Problems

[Joe Chandler <jo...@autodesk.com>]

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

 

 

 

RE: Oracle 9.2 Provider Problems

[Alexey Boroday <a....@procreditbank.com.ua>]

Hello.

Could you see in the tool like SQL profiler or some SQL trace monitor what
SQL statement is passed to the server?

> -----Original Message-----
> From: Joe Chandler [mailto:joe.chandler@autodesk.com] 
> 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.


___________________________________________________________________________

This communication is confidential and may be legally privileged. 
If you believe you are not an intended recipient, please inform the sender, 
delete the e-mail and do not copy, print or use it or disclose it to others. 
You can inform the sender by replying to this e-mail or by telephone (+380 44 4906080).