Migrating routine files to Optim Development Studio Version 2.2.1.1

When you migrate a workspace to Optim Development Studio Version 2.2.1.1, routine files are not automatically migrated to the Version 2.2.1.1 routine file format. To migrate a routine file, you must make a change to the routine with the routine editor and save it. A routine file is a file that contains a stored procedure, a user-defined function, or a PL/SQL package.

About this task

Optim Development Studio Version 2.2.1.1 automatically migrates the format of a routine file from a previous version of Optim Development Studio when a change is made to the routine or if you deploy a routine with Optim Development Studio Version 2.2.1.1 and the deployment causes the routine to be modified and saved. To manually change the routine file format to the Version 2.2.1.1 format, open the routine in the routine editor, edit it, and save the routine.

Procedure

To migrate routine files with Optim Development Studio Version 2.2.1.1:

  1. Open a workspace.
  2. In the Data Project Explorer, browse to a project folder that contains stored procedures, user-defined functions, or PL/SQL packages.

    If you browse to project files in an other view like the Project Explorer, the stored procedure files have the file extension spxmi, the user-defined function files have the file extension udfxmi, and PL/SQL package files have the file extension pkgxmi.

  3. Open the routine file with the routine editor, make a change to the routine, and save the routine.

Results

After you migrate a routine to Optim Development Studio version 2.2.1.1, you cannot use the routine with a previous version of Optim Development Studio.

Feedback