Stored Procedures

Managing stored procedures only applies to Oracle databases. If you do not use Oracle, you do not need to use this page. You must use this administration page when you first install FCFL, and every time you add another Long Varchar to the data schema.

Here you can create, view, and compile the stored procedure used to handle the Oracle Long Varchar* limitation of 4000 characters.

1. Select Build Stored Procedure. The stored procedure will be built and displayed.
2. To compile the stored procedure, select Save To File.
3. Select a file name.
4. Enter login data and the file name from step 3.
5. Select Compile Stored Procedure. This will start a session for the compilation. Once completed, the results will be displayed.

* The term varchar, or variable character field, refers to a common data type in database management systems.

Did this topic help you? Email us your feedback.
Last updated: 10/17/2007 4:16:36 PM
© by Dovetail Software, Inc.