Stored procedures are an integral part of both the staging area and the target system implementation. After you have created and configured the SmartPlant Foundation site in SmartPlant Foundation Server Manager, you must update each stored procedure so that they match the correct index, name, and data table spaces.
If you are upgrading, the stored procedures may have changed and require a manual
update. Always refer to the release notes or read me file for any changes.
The procedure files are located at [drive]:\ Program Files (x86)\[Product Folder]\SPFServerManager\DatabaseScripts\Stored Procedures\[DB Type].
For example
create or replace PROCEDURE ICI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE ICT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';
create or replace PROCEDURE TCI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE TCT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';
create or replace PROCEDURE TCFI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE TCFT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';