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.
- RAW_TO_NUMBER - Converts RAW byte string to Oracle number.
- WMSG - Returns the warning message.
- WMSGCNT - Returns the count of warning messages.