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:[EMAIL PROTECTED] > 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).
