The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_null_object_versions IS
BEGIN
SAVEPOINT CCTUPGCOL;
UPDATE cct_middlewares
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_CLASSIFICATIONS
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_CLASSIFICATION_RULES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_IVR_MAPS
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_LINES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_MIDDLEWARE_PARAMS
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_MIDDLEWARE_VALUES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_TELESET_TYPES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_STATIC_ROUTES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_ROUTE_PARAMS
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_ROUTES
SET object_version_number = 0
where object_version_number IS NULL;
UPDATE CCT_TELESETS
SET object_version_number = 0
where object_version_number IS NULL;
raise_application_error(-20000, sqlerrm || '.UPDATE COL VALUE, Could not add column') ;
PROCEDURE update_route_param_operator(schema_name IN VARCHAR2) is
l_str varchar2(200):= 'ALTER TABLE ' || schema_name || '.' ||'CCT_ROUTE_PARAMS MODIFY ( OPERATION DEFAULT '''||'='||''' )';
UPDATE CCT_ROUTE_PARAMS
SET operation = '='
where operation IS NULL;
raise_application_error(-20000, sqlerrm || '.UPDATE_ROUTE_PARAM_OPERATOR COL VALUE, Could not modify') ;
END update_route_param_operator;