Updating lobs using oraclecommand and oracleparameter

updating lobs using oraclecommand and oracleparameter-65

is not explicitly set, it is inferred from the actual size of the specified parameter value when binding only for input parameters.

Output parameters must have their size defined explicitly.

property should be set to the name of the stored procedure.

The user may be required to use escape character syntax if the stored procedure name contains any special characters.

The magic is going to occur from the fact we are locking this row for update and passing back the reference to this table inside the ref cursor. NET code string connection String = Configuration Manager. Call read on the datareader, next we are going to get clob column from the data reader.