APIs Defined in ECX_ENG_UTILS

convert_to_cxml_date

PL/SQL Syntax

procedure convert_to_cxml_date
(p_ora_date in date,
 x_cxml_date out varchar2);

Description

Converts Oracle date to cXML date in ISO 8601 format. The time element is not included.

If both date and time are required, use convert_to_cxml_datetime procedure.

Arguments (input)

p_ora_date The Oracle date.

Arguments (output)

x_cxml_date The cXML date converted from the Oracle date.

convert_to_cxml_datetime

PL/SQL Syntax

procedure convert_to_cxml_datetime
(p_ora_date in date,
 x_cxml_date out varchar2);

Description

Converts Oracle date and time to cXML date and time in ISO 8601 format.

If only the date is required, use convert_to_cxml_date procedure.

Attention: Be sure to set the profile option ECX: Server Time Zone. If you do not set this profile option, the time zone defaults to GMT. See Define System Profile Options.

Arguments (input)

p_ora_date The Oracle date and time.

Arguments (output)

x_cxml_date The cXML date and time converted from the Oracle date and time.

convert_from_cxml_datetime

PL/SQL Syntax

procedure convert_from_cxml_datetime
(p_cxml date in varchar2,
 x_ora_date out date);

Description

Converts cXML date and time to Oracle date and time.

Attention: Be sure to set the profile option ECX: Server Time Zone. If you do not set this profile option, the time zone defaults to GMT. See Define System Profile Options.

Arguments (input)

p_cxml_date The cXML date and time on an incoming document.

Arguments (output)

x_ora_date The Oracle date and time converted from the cXML date and time.