1
Vote

Workflow Tracking (InsertWorkflowInstance) fails under ODP.NET

description

Running 0.3.0.0 Changeset 15876, with ODP.NET 2.111.6.20 against Oracle 9i 9.2.0.5.0.
 
Under ODP.NET, AdoTrackingResourceAccessor.InsertworkflowInstance fails with an error "ORA-01460: unimplemented or unreasonable conversion requested" when trying to retrieve the Instance ID from the RefCursor returned by the InsertWorkflowInstance stored proc on the following line:
 
workflowInstanceSummary.InternalId = _valueReader.GetInt64(dataReader, 0);
 
Recommended change: Pass the workflow_instance_id back as a number (WORKFLOW_INSTANCE.WORKFLOW_INSTANCE_ID%TYPE) rather than a RefCursor. Other stored procs in this package (e.g. InsertWorkflowTrackingRecord) already work this way.

comments