SQL-002 Select a single task¶

Retrieves a single TASK row via the Oracle stored procedure pk82036_task.task_select, which returns a REF CURSOR.

Classification¶

Field	Value
SQL ID	SQL-002
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	`[unqualified]`**
Command type	StoredProcedure
Business object	`clsTask`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve` / `AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:TaskID`	Input	Decimal	N/A	`TASK_SEQ_NUM` of the task to load
`recordset`	Output (Cursor)	Oracle `SYS_REFCURSOR`	N/A	Result set consumed as `clsSAIFDataReader` in `AfterRetrieve` (`AddCursorParm("recordset")`)

Tables¶

Table	Access	Columns used
TASK	SELECT	All 19 task columns plus the six `Context*` columns mapped by `Fill`

Sample SQL¶

-- CommandType.StoredProcedure, REF CURSOR output
CALL pk82036_task.task_select(
  :TaskID,
  :recordset)

:recordset is an Oracle SYS_REFCURSOR OUT parameter registered via DataRequest.AddCursorParm("recordset") and consumed as a clsSAIFDataReader in AfterRetrieve. The procedure body resides in the Oracle database and was not retrieved in this environment.**

Operations and processes¶

Retrieve a single task

Sources¶

SAIF.Business.Tasks/clsTask.vb