📄 user_guide.htm

📁 Oracle PL/SQL procedure generator (second generator type)
💻 HTM
字号:
<HTML>
<HEAD>
<TITLE>PL/Generator User Guide</TITLE>
</HEAD>
<BODY bgcolor="white" background="bar_products.gif">

<table border=0 cellspacing=0 cellpadding=0 valign=top  width=750>
<tr><td width="51" valign=top>

<br>

<td valign="top" width="699">

<IMG SRC="generator.gif" WIDTH=285 HEIGHT=48><BR>
<B><FONT   SIZE=5>Installation and API User's Guide</B></FONT>

<P>
<hr>
<P>

<TABLE CELLSPACING=0 BORDER=0 CELLPADDING=7 WIDTH=590>
<TR><TD VALIGN="TOP" BGCOLOR="#000000">
<P><B><FONT FACE="New York,Times New Roman" SIZE=5 COLOR="#ffffff">Table of Contents </B></FONT></TD>
</TR>
</TABLE>

<P>

<P><A HREF="Introduction.htm"><B><FONT SIZE=4>Part 1: Introduction</B></FONT></A>
<P><A HREF="Installation.htm"><B><FONT SIZE=4>Part 2. Installation</B></FONT></A>
<P><A HREF="Get_Started.htm"><B><FONT SIZE=4>Part 3. Getting Started with PL/Generator</B></FONT></A>
<P><A HREF="Generator_API.htm"><B><FONT SIZE=4>Part 4. Using the PL/Generator API</B></FONT></A>
<P>

<A HREF="#Support"><I>Quest Software Technical Support</I></A><BR>
<A HREF="#Limitations"><I>Limitations, Restrictions, Troubleshooting</I></A><BR>
<A HREF="#Acknowledgements"><I>Acknowledgements</I></A><BR>
<A HREF="#Notice"><I>Notice</I></A>

<A NAME="Support">
<hr>
<P>

<B><FONT   SIZE=4><P>Quest Software Technical Support</A></B></FONT>
  <p>THIS VERSION OF PL/GENERATOR IS NOT SUPPORTED BY QUEST SOFTWARE!</p>
  <p>We are making this software available to you as a service to the PL/SQL
  development community. Do not contact Quest Support if you have difficulties
  with this software. You can send a message to Steven Feuerstein at <a href="mailto:steven@stevenfeuerstein.com">steven@stevenfeuerstein.com</a>,
  but we cannot at this time guarantee that your questions can be addressed.</p>
  <p>You may use this software at your own risk, and there is no fee for usage.
  This software is, however, owned and copyrighted by Quest Software. You may
  not use this software, in part or in whole, in any commercial transaction of
  your own. You may only use PL/Generator for its intended purpose of generating
  encapsulation packages for your tables and views, in your development
  environment.</p>
<P>
<A NAME="Limitations"></A>

<HR>
<P>
<B><FONT  SIZE=4>Limitations, Restrictions, Troubleshooting </B></FONT>

<UL>
<LI>Table names and column names should not exceed 26 characters (or less, depending on your naming conventions set through aliases). Run the PLGval.show_invalid_idents to see if your naming conventions and table/columns names will generate invalid identifiers. </LI>
<LI>If you choose any of the pre-load options (loadall, loadincr), you must compile and use that package on Oracle 7.3 or above (it relies on index tables of records). </LI>
<LI>If you create an index for your primary key before you define the primary key constraint, PL/Generator will currently create two different functions to return values based on the primary key and then also on the unique index. </LI>
<LI>While PL/Generator will run on Oracle8, it does not yet support generation of code based on Oracle8-specific objects. </LI>
<LI>Any triggers that act on or are triggered by changes in specific column values should always use the WHEN clause to avoid execution when :old is equal to :new. The general update procedure does update all non-primary key columns in the table; it may just update one, more or most to the current value. </LI>
<LI>PL/Generator will not work properly unless your table has a primary key (or you have specified the emulation of a primary key through the OIR with calls to PLGdoir.setpkycol). </LI>
<LI>PL/Generator will not allow you to update the values of primary key columns(s). </LI>
<LI>PL/Generator will create package bodies that are likely to be too large to compile if your table has more than 170 columns (approximately). Oracle 8.1 will remove this restriction.</LI>
<LI>If you are running the PL/Generator backend on a Unix server, then you will be copying the driver files (*.gdr) from your Windows install machine to Unix. You should convert the DOS-format files to Unix files (there are different characters for indicating end of line) to avoid driver read errors.
</UL>
<P>

<A NAME="Acknowledgements"> 
<HR> 

<B><FONT   SIZE=4><P>Acknowledgements</A></B></FONT>
<P>
Microsoft&reg; is a U.S. registered trademark of Microsoft Corporation.<BR>
Windows&trade; is a trademark of Microsoft Corporation.<BR>
Oracle&reg; is a U.S. registered trademark of Oracle Corporation.<BR>
PL/SQL&trade; is a trademark of Oracle Corporation.<BR>
PL/Generator&trade; is a trademark of Quest Software, Incorporated.<BR>
PL/Vision&trade; is a trademark of Quest Software, Incorporated.<BR>

<A NAME="Notice">
<HR> 

<B><FONT   SIZE=4><P>Notice</A></B></FONT>
<P>
The information contained in this document is subject to change without notice. Quest Software makes no warranty of any kind with regard to this material, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Quest Software shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance, or use of this material. No part of this document may be photocopied, reproduced, or translated to another language without the prior written consent of Quest Software, Inc. 
<P>&nbsp;<I>PL/Generator: Installation and API User抯 Guide</I>, Edition 1, July 1998<BR>
&copy; Copyright 1998 by Quest Software, Incorporated<BR>
All rights reserved<BR>
Manual Part Number: R0630-98001 

<P>
<HR>

<font size="2">
<p align="center"> Main  |  
<a href="Introduction.htm"> Introduction </a>  |  
<a href="Installation.htm"> Installation </a>  |  
<a href="Get_Started.htm"> Getting Started </a>  |  
<a href="Generator_API.htm"> PL/Generator API </a>  
</font>
<p>

<hr>
<p align="center"><font size="1">Copyright
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -