Using OCI parameters

4D v17

The structure of dates is different between 4D and Oracle. Oracle includes the time in date fields while 4D sets a specific variable for time. As a result, when passing OCI date parameters, the Oracle dates were divided into date and time.

Example

The OCIDateToText command initially accepts a date (date) as the second parameter and then its format (fmt) as the third parameter.
As for 4D for OCI, the date (date) parameter becomes two different parameters for date and time and the format parameter becomes the fourth parameter.

Once a text parameter is passed, the OCIs expect a parameter specifying the length of the text. 4D for OCI handles the passage of this parameter, which means that the developer no longer has to pass it.

Example

The OCILogon command initially accepts the user name (username) as the third parameter and its length (uname_len) as the fourth parameter. In this case, 4D for OCI frees the developer from passing the length parameter. Thus, the fourth parameter becomes the password (password).