__IF_EXISTS__
SELECT 1 FROM CI_UT_INSTL_DTL WHERE SCRIPT_FILE_NAME = 'FW44022_BPSCHEMA_UGBUPD-5885.sql' AND END_DTTM IS NOT NULL
/
__THEN__

__EXIT__

__ENDIF__


__IF_EXISTS__
SELECT 1 FROM USER_TAB_COLUMNS  WHERE TABLE_NAME = 'CI_BATCH_INST' AND COLUMN_NAME = 'FILE_DETAILS'
/
__THEN__
ALTER TABLE CI_BATCH_INST ADD FILE_DETAILS_CLOB CLOB
/
UPDATE CI_BATCH_INST SET FILE_DETAILS_CLOB=FILE_DETAILS
/
ALTER TABLE CI_BATCH_INST DROP COLUMN FILE_DETAILS
/
ALTER TABLE CI_BATCH_INST RENAME COLUMN FILE_DETAILS_CLOB TO FILE_DETAILS
/
__ENDIF__

