📄 index.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">
<DIR>
<BR>
<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>
<UL>
<LI><A HREF="Introduction.htm"><B><FONT SIZE=4>Part 1: Introduction</B></FONT></A><P>
<LI><A HREF="Installation.htm"><B><FONT SIZE=4>Part 2. Installation</B></FONT></A><P>
<LI><A HREF="Get_Started.htm"><B><FONT SIZE=4>Part 3. Getting Started with PL/Generator</B></FONT></A><P>
<LI><A HREF="Generator_API.htm"><B><FONT SIZE=4>Part 4. Using the PL/Generator API</B></FONT></A><P>
<LI><A HREF="cgml.htm"><B><FONT SIZE=4>Part 5. Using CGML </B></FONT></A><P>
</UL>
<HR>
<UL>
<LI><A HREF="#Support"><B>Quest Software Technical Support</B></A><P>
<LI><A HREF="#Limitations"><B>Limitations, Restrictions, Troubleshooting</B></A><P>
<LI><A HREF="#Acknowledgements"><B>Acknowledgements</B></A><P>
<LI><A HREF="#Notice"><B>Notice</B></A><P>
<LI><A HREF="Release Notes.htm"><B>Release Notes</B></A>
<P></UL>
<A NAME="Support">
<hr>
<B><FONT SIZE=4><P>Quest Software Technical Support</A></B></FONT>
<P>
Our Technical Support staff is ready to assist you with any problem you may have with your Quest Software software.
<P>
There are many ways to contact Quest Software support. It would be helpful if you are near your computer and have PL/Generator running (if possible) when you call. This will help us find a solution quickly and efficiently.
<DIR>
<P>E-Mail:			support@Quest Software.com<BR>
World Wide Web:	http://www.Quest Software.com<BR>
Technical Support:	(540) 373-7703<BR>
			Monday - Friday, 8:00 am - 5:00 pm, EST<BR>
Technical Fax:		(540) 373-7724
</DIR>
<P>
<A NAME="Limitations"></A>
<HR>
<P>
<B><FONT SIZE=4>Limitations, Restrictions, Troubleshooting </B></FONT>
<P>
<UL>
<LI>
<p style="margin-top: 3; margin-bottom: 5">The PL/Generator Interface can currently only generate code for the Table Encapsulation
driver. If you have both PL/Generator and Quest Software's Gen/X products installed,
PL/Generator will list additional drivers in its list. DO NOT try to generate code from these
drivers. This will result in error message: "200000 - No database objects found matching [object name]".
</LI>
<LI>
<p style="margin-top: 3; margin-bottom: 5">Do not hide columns (exempt them
from the generated API) that are part of a unique index. This will cause
generation of code that will not compile.
</LI>
<LI>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">While PL/Generator will run on Oracle8, it does not yet support generation of code based on Oracle8-specific objects. </LI>
<LI>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">PL/Generator will not allow you to update the values of primary key columns(s). </LI>
<LI>
<p style="margin-top: 3; margin-bottom: 5">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>
<p style="margin-top: 3; margin-bottom: 5">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>
<P>
<B><FONT SIZE=4><P>Acknowledgements</A></B></FONT>
<P>
Microsoft® is a U.S. registered trademark of Microsoft Corporation.<BR>
Windows™ is a trademark of Microsoft Corporation.<BR>
Oracle® is a U.S. registered trademark of Oracle Corporation.<BR>
PL/SQL™ is a trademark of Oracle Corporation.<BR>
PL/Generator™ is a trademark of Quest Software, Incorporated.<BR>
PL/Vision™ is a trademark of Quest Software, Incorporated.<BR>
<P>
<A NAME="Notice">
<HR>
<P>
<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>
<I><P>PL/Generator: Installation and API User抯 Guide</I>, Edition 99.1, May 1999<BR>
© Copyright 1999 by Quest Software, Incorporated<BR>
All rights reserved<BR>
Manual Part Number: R0503-99001
<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 + -