Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL UTL_PG Package      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 65 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?