我的应用程序使用TimesTen DB来存储数据 . 下面是我更新数据并返回更新行的代码 .
conn = new OracleConnection("My Connection");
conn.Open();
OracleTransaction tran = conn.BeginTransaction(IsolationLevel.ReadCommitted);
OracleCommand command = new OracleCommand();
command = new OracleCommand(@"DECLARE idNo NUMBER;
BEGIN
select id into idNo from " + prefix_db + @"tbl_request_in where upper(status)='PENDING' and ROWNUM <= 1 order by priority, id FOR update;
update " + prefix_db + @"tbl_request_in set status ='Processing',begin_time= SYSDATE(),response_node='10.9.70.47'
where upper(status) <> 'PROCESS' and upper(status) <> 'PROCESSING' and upper(status) <> 'OK' and upper(status)<>'ERROR'
and id=idNo;
OPEN :RETURNCURSOR for select * from APITT_tbl_request_in where id=idNo;
END;", conn);
command.Transaction = tran;
command.BindByName = true;
OracleParameter outNumPrm = command.Parameters.Add("RETURNCURSOR", OracleDbType.RefCursor, DBNull.Value, ParameterDirection.ReturnValue);
// create a data adapter to use with the data set
OracleDataAdapter da = new OracleDataAdapter(command);
// create the data set
DataSet ds = new DataSet();
// fill the data set
da.Fill(ds);
我给出了错误
{Oracle.DataAccess.Client.OracleException ORA-01722:Oracle上的Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,OracleConnection conn,IntPtr opsErrCtx,OpoSqlValCtx * pOpoSqlValCtx,Object src,String procedure,Boolean bCheck)中的无效数字System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)中的Oracle.DataAccess.Client.OracleDataReader.Read().DataAccess.Client.OracleException.HandleError(Int32 errCode,OracleConnection conn,IntPtr opsErrCtx,Object src,Boolean bCheck) System.Data.Com上的System.Data.Common.DataAdapter.FillFromReader(DataSet数据集,DataTable datatable,String srcTable,DataReaderContainer dataReader,Int32 startRecord,Int32 maxRecords,DataColumn parentChapterColumn,Object parentChapterValue),System.Data.Common.DataAdapter.Fill(DataSet dataSet,String Oracle.DataAccess.Client.OracleDataAdapter.Fill中的srcTable,IDataReader dataReader,Int32 startRecord,Int32 maxRecords)(DataSet dataSet,String srcTable,IDataReader dataReade)在System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)的Oracle.DataAccess.Client.OracleDataAdapter.Fill(DataSet dataSet,Int32 startRecord,Int32 maxRecords,String srcTable,IDbCommand command,CommandBehavior behavior)中的r,Int32 startRecord,Int32 maxRecords) )
我该如何解决?
1 回答
匿名PL / SQL块不能返回任何值 . 写一个这样的函数:
并调用此函数
如果您无法在数据库中创建函数,请尝试将字符串
APITT_tbl_request(:prefix_db);
替换为函数体,但我不知道这是否有效 .