installation.htm

Oracle PL/SQL procedure generator (second generator type)

For the resulting code to compile, you must grant EXECUTE authority on PLVdyn. To do this for PUBLIC, you would connect to the schema that owns the PL/Vision software and execute this statement:<BR>
            <p>

<FONT FACE="Courier New" SIZE=2>SQL> grant execute on PLVdyn to PUBLIC;</font>

		</TD>

	</TR>

</TABLE>



<P>

You can then examine the settings for the demonstration tables (employee, department, loc and job) through the screen interface. From there you can generate the code from these specifications. Alternately, you can examine the generated code that is supplied in the directory. 

<P>

You can also compile all of the pre-generated code that was based on the characteristics set by tedemo.sql. The easiest way to do this is to execute either the tedemo.cmp or tedemou.cmp scripts, also in the PL/Generator demo directory.  

<P>

The tedemo.cmp script assumes that you have placed the software in the c:\temp directory and that you are executing the code in a Windows environment. You will need to change this directory to your Generate To

location.

<P>

The tedemou.cmp script assumes that you have placed the software in the /tmp directory and that you are executing the code in a Unix environment. You will need to change this directory to your Generate To location.

<P>

In both cases, run SQL*Plus and connect to the schema that owns the demonstration tables. Then start up the compile script.  

<P>

The following table summarizes the various demonstration files. 

<P ALIGN="RIGHT"><TABLE CELLSPACING=1 BORDERCOLOR="#000000" CELLPADDING=7 WIDTH=700>

<TR><TD WIDTH="18%" VALIGN="TOP" BGCOLOR="#ffffff">

<P><B>File</B></FONT></TD>

<TD WIDTH="82%" VALIGN="TOP" BGCOLOR="#ffffff">

<B><P>Description</B></TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>tedemo.sql</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>Creates the tables (these are taken from the standard Oracle demo tables, but with some changes) and sets up the Object Information Repository for these tables.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>tedemo.gen</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>Generates the packages for all four tables, including the test packages.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>tedemo.cmp</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>Compiles in Windows the packages for all four tables, including the test packages. </TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>tedemou.cmp</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>Compiles in Unix the packages for all four tables, including the test packages. </TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>tedemo.drp</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>Script to drop tables, packages and sequences.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>te_employee.*</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>All of the generated code for the employee table.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>te_department.*</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>All of the generated code for the department table.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>te_job.*</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>All of the generated code for the job table.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>te_loc.*</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>All of the generated code for the loc table.</TD>

</TR>

<TR><TD WIDTH="18%" VALIGN="TOP">

<P>te_locemp.*</TD>

<TD WIDTH="82%" VALIGN="TOP">

<P>All of the generated code for the locemp table.</TD>

</TR>

</TABLE>

 



<B><FONT  SIZE=4><P ALIGN="RIGHT">&nbsp; 

<P>

&nbsp;<A NAME="PLG">Removing PL/Generator</A>  

</B></FONT>

<P>

To remove or de-install PL/Generator, you will need to drop the packages and tables from your Oracle instance and also remove the software from your hard drive. 



<P>

<B><A NAME="Objects">Removing Objects from Database</A> </B>



<P>

You will need to remove PL/Vision software (if you are not licensed to use this software) and PL/Generator software. <P>

To remove PL/Vision software, start up a SQL*Plus session with the current working directory set to that containing PL/Vision source code. Connect to the schema owning the code (the default is PLGENERATOR) and take the following steps. 

<P>

To remove all the public synonyms for PL/Vision packages, connect to the owning schema in SQL*Plus and issue this command: <DIR>



<FONT FACE="Courier New" SIZE=2>

<P>

SQL&gt; @plvdpsyn &lt;connect_string&gt; </DIR>

</FONT>

<P>

where &lt;connect_string&gt; is the connect string (username/password) for a DBA account from which public synonyms can be dropped. 

<P>

To drop private synonyms for each of the PL/Vision packages, execute the plvdsyn.sql script from the account that has the private synonyms as follows: <DIR>



<FONT FACE="Courier New" SIZE=2>

<P>

SQL&gt; @plvdsyn  </DIR></FONT>


<P>

Execute the following script to remove all PL/Vision tables: <DIR>



<FONT FACE="Courier New" SIZE=2>

<P>

SQL&gt; @plvtrem  </DIR></FONT>




<P>

You are now ready to remove the packages that make up PL/Vision. To do this, connect to the schema owning the PL/Vision objects and issue the following command: <DIR>



<FONT FACE="Courier New" SIZE=2>

<P>

SQL&gt; @plvprem  </DIR></FONT>



<P>

When these steps are completed, all tables, packages and synonyms for PL/Vision will then be dropped. 

<P>

To drop PL/Generator objects, start up a SQL*Plus session with the current working directory set to that containing PL/Generator source code. Connect to the schema owning the PL/Generator objects and issue this command in SQL*Plus: <DIR>



<FONT FACE="Courier New" SIZE=2>

<P>

SQL&gt; @plgrem  </DIR></FONT>





<P>

At this point, you will have removed all PL/Vision and PL/Generator objects from the database. 

<B><FONT  SIZE=4><P><A NAME="PLG_Objects">PL/Generator Objects</A> </FONT>

 </B>

<TABLE CELLSPACING=1 CELLPADDING=7 WIDTH=498>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P><B>Name</B></TD>

<TD WIDTH="71%" VALIGN="TOP">

<B><P>Description</B></TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGADMIN </TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Administrative routines (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGPRIV</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Manages privileges (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGGEN</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Generator engine (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGDOIR</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Object Information Repository manager (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGTE</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Table Encapsulator front-end (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGDESC</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Code descriptor (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGGENV</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Generator variable space (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGERR</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Error handler (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLGVAL</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Validation routines (package)</TD>

</TR>

<TR><TD WIDTH="29%" VALIGN="TOP">

<P>PLG_DOIR</TD>

<TD WIDTH="71%" VALIGN="TOP">

<P>Object Information Repository table</TD>

</TR>

</TABLE>













<P>

<hr>

<font size="2">

<p align="center"><a href="User_Guide.htm"> Main </a>  |  

<a href="Introduction.htm"> Introduction </a>  |  

Installation  |  

<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