OCIDefineDateByPos

4D v16

OCIDefineDateByPos


OCIDefineDateByPos ( stmtp ; defnnpp ; errhp ; position ; valuep ; valuep2 ; dty ; indp ; rlenp ; rcodep ; mode ) -> 戻り値

引数	型	説明
stmtp	倍長整数	Handle to requested SQL query operation

defnnpp	倍長整数	Define handle

errhp	倍長整数	Error handle

position	倍長整数	Position of value in list
valuep	ポインター	Buffer(s) of type specified in dty parameter

valuep2	ポインター	Buffer(s) of type specified in dty parameter

dty	倍長整数	Datatype
indp	ポインター	Indicator variable or array
rlenp	ポインター	Array of length of data fetched

rcodep	ポインター	Array of column-level return codes
mode	倍長整数	Specifies mode of operation
戻り値	倍長整数	Status

説明

Please refer to the OCIDefineDateByPos command in the OCI documentation provided by Oracle for more information.

Note: The OCIDefineDateByPos command is similar to the OCIDefineByPos command except that there is an additional valuep2 parameter to adapt it for working with Oracle columns of the TIMESTAMP type. For this command, the valuep parameter is a pointer to a date (C_DATE) and valuep2 is a pointer to a time (C_TIME). When both parameters are used, the command takes the date (day/month/year) from the valuep parameter and the time (hour:minute:second) from the valuep2 parameter.

例題

See the example for Working with Oracle Date types.