c-treeACE V11.0 Update Guide

Editing Stored Procedures

To edit stored procedures in NetBeans:

1. Create a new project using File > New Project.
2. In Categories, select FairCom and in Projects select Stored Procedures & ... then click Next.
   Update the project name and location information as you desire then click Next.
3. Select the desired JDBC connection for the project to be able to deploy and retrieve stored procedures. This selection can be changed later in the project properties under FairCom Server.

   
   

4. Click Finish.

   
   

5. Create a new stored procedure using these steps:
   1. Right-click the project and select New then select Other (if the project is not already listed).

   
   

   1. Click Categories > FairCom > File types and select the appropriate type for the project you desire to build (e.g., FairCom Stored Procedure). Follow the wizard for additional steps.

   
   

   1. Write the code for your stored procedure.
      

   Note: Stored procedure names are case-sensitive (as is any other database object). To reference a case, you need to quote it as is done for other identifiers. For example:
   CALL "Tutorial1"()

6. Import the project from the server by right-clicking on the project stored_proc package and clicking Import from server.