How do you create a pl/sql objects using the templates? I cannot find the create option that will apply the code template specifically for my objects, i.e. procedures and packages(spec and body).
To Create a New PL/SQL Object:
1. From the Editor, click the Create New PL/SQL Object button in the toolbar.
2. Select the type of object you want to create:
Function
Procedure
Package (spec)
Package Body
Type (spec)
Type Body
Trigger
3. Enter the name of your new object in the New Object Name box, or leave this blank for now and enter a name when you save the object.
The default templates are read from the Toad for OracleUser Files folder. If you want to use a template you have created other than the default, choose it from the drop down menu. The following default templates are located in the Toad for OracleUser Files folder:
NEWPROC.SQL For creating a new Procedure
NEWFUNC.SQL For creating a new Function
NEWPackage.SQL For creating a new Package spec
NEWPackageBody.SQL For creating a new Package body
NEWType.SQL For creating a new Type spec
NEWTypeBody.SQL For creating a new Type body
NEWTrigger.SQL For creating a new Trigger spec
Note: In addition to the above templates, there are two others stored in the Toad/User Files folder and editable as described below. These are useable within a created package and include both Package Procedures and Package Functions. See Using Templates within Packages for more information.
5. You can edit these files in the Editor as desired, perhaps to adjust the comment prolog, standard error handling section, and so on. Use any text editor, or select the file from the Toad Options|Editor|Proc Templates topic and click Edit.
6. You can also delete, change, or add new files as desired. See Toad Options|Editor|Proc Templates.
7. You can load these New Procedure templates from any network path.
Simply specify where the files are located when you add them to the list. To change the path, you will need to add the new path and delete the old entry.
This information is also located in the Toad Help file.
The Datebase menu | Create | Object will give you a window to help create the script for object creation based of a simple shell of the object code and entered values. But this is different from the outline specified in a saved template.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center