Definition: In Oracle, UTL_PG is a built in package which supports the Oracle Procedural Gateway i.e. the conversion of COBOL number formats to Oracle numbers and vice versa. Oracle Procedural Gateway allows PL/SQL programs to be used in client side applications to execute a Remote Transaction Program at the server. UTL_PG, along with UTL_RAW ensures the interaction of unaltered RAW data from PL/SQL on the network channel.

The subprograms under UTL_PG are listed below.

MAKE_NUMBER_TO_RAW_FORMAT - Create a format for NUMBER_TO_RAW to specify to precision and scale.

NUMBER_TO_RAW_ FORMAT - Convert an Oracle number to a RAW byte format in remote host internal format, as specified in the conversion format.

NUMBER_TO_RAW - Convert Oracle Number to a RAW byte string.

MAKE_RAW_TO_NUMBER_FORMAT - Create a format for RAW_TO_NUMBER to specify precision and scale.

RAW_TO_NUMBER_FORMAT - Convert an RAW byte string to a Oracle number format in remote host internal format, as specified in the conversion format.