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:
- Open a workspace.
- 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.
- 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.