Quick Search:
 
 The Oracle PL/SQL UTL_PG Package      [Return To Index] Jump to:  

Term: UTL_PG

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.

 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org