Hi all,
I am using the System.Data.OracleClient on an Oracle 8.17 database. The
problem I have is that when I define an output parameter I can see the
retreived value within the RowUpdated event of the OracleDataAdapter but the
value is never actually being put back into the dataRow.
For the parameter I define:
ParameterName = "EMP_SAL"
SourceColumn = "SAL"
SourceVersion = DataRowVersion.Current
ParameterDirection = ParameterDirection.Output
The EMP_ENAME and EMP_EMPNO parameters are defined as InputOutput. And the
command that is executed with OracleDataAdapter.Update(row) is:
begin
insert into EMP (ENAME, EMPNO) values (:EMP_ENAME, :EMP_EMPNO);
select SAL, ENAME into :EMP_SAL, :EMP_ENAME from EMP where EMPNO =
:EMP_EMPNO;
end;
The reason I want to use an ouput parameter is because in my example the SAL
column in the database has a default value I want to retrieve. In a more
realistic example the SAL column could be calculated.
The obvious fix is to manually put the value back into the DataRow during
the RowUpdated event. Is this a known bug? Any other suggestions?
With kind regards,
Robert van Poelgeest