We have a procedure that was running fine, but now we receive this error - ORA-53203 Security Violat
Problem Description: We have a procedure that has been running fine, until we installed Oracle 10.2. now we receive the security violation. Here is part of the procedure:
---USER STD DATA FILE
V_FILE_HANDLEUSER := UTL_FILE.FOPEN ('DATA_FILE_DIR', V_USER_STD, 'W',32767);
SELECT 'SYSTEM_ROLE|INSTITUTION_ROLE|EXTERNAL_PERSON_KEY|USER_ID|PASSWD|FIRSTNAME|LASTNAME|EMAIL|ROW_STATUS|AVAILABLE_IND'
INTO V_USER_HEADER
FROM DUAL ;
UTL_FILE.PUT_LINE (V_FILE_HANDLEUSER,
V_USER_HEADER);
FOR USER_STD_REC IN USER_STD_CURSOR LOOP
V_USER_STD_CNT := V_USER_STD_CNT + 1;
UTL_FILE.PUT_LINE (V_FILE_HANDLEUSER,
---USER STD DATA FILE
V_FILE_HANDLEUSER := UTL_FILE.FOPEN ('DATA_FILE_DIR', V_USER_STD, 'W',32767);
SELECT 'SYSTEM_ROLE|INSTITUTION_ROLE|EXTERNAL_PERSON_KEY|USER_ID|PASSWD|FIRSTNAME|LASTNAME|EMAIL|ROW_STATUS|AVAILABLE_IND'
INTO V_USER_HEADER
FROM DUAL ;
UTL_FILE.PUT_LINE (V_FILE_HANDLEUSER,
V_USER_HEADER);
FOR USER_STD_REC IN USER_STD_CURSOR LOOP
V_USER_STD_CNT := V_USER_STD_CNT + 1;
UTL_FILE.PUT_LINE (V_FILE_HANDLEUSER,
0