| |
1. 통신에 문제가 있을 때
'General SQL error.'#$D#$A'ORA-03113: end-of-file on communication channel'
General SQL error.
ORA-03113: end-of-file on communication channel
2. 접속이 되지 않을 때
'Unknown network error.'#$D#$A'ORA-12203: TNS:unable to connect to destination'
#$D#$A'Alias: wingp5000'
Unknown network error.
ORA-12203: TNS:unable to connect to destination
Alias: wingp5000
3. 세션이 종료되었을 때
'General SQL error.'#$D#$A'ORA-00028: your session has been killed'
General SQL error.
ORA-00028: your session has been killed
참고: 세션 강제 종료
1) Select * from v$session
2) SID와 #Serial 확인
3) Alter System Kill Session 'SID, #Serial'
4. 연결되지 않았을 때
'General SQL error.'#$D#$A'ORA-03114: not connected to ORACLE'
General SQL error.
ORA-03114: not connected to ORACLE
5. 테이블이 존재하지 않을 때
'Table does not exist.'#$D#$A'ORA-00942: table or view does not exist'
Table does not exist.
ORA-00942: table or view does not exist
6. NOT NULL인 컬럼이 비워져 있을 때
'Field value required.'#$D#$A'ORA-01400: mandatory (NOT NULL) column is missing
or NULL during insert'
Field value required.
ORA-01400: mandatory (NOT NULL) column is missing or NULL during insert
7. ExecSQL 사용해야 할 곳에 Open을 사용했을 때
'Error creating cursor handle'
Error creating cursor handle
8. 구문 에러가 났을 때
'General SQL error.'#$D#$A'ORA-01031: insufficient privileges'
General SQL error.
ORA-01031: insufficient privileges
9. 컬럼이 유효하지 않을 때
'General SQL error.'#$D#$A'ORA-00984: column not allowed here'
General SQL error.
ORA-00984: column not allowed here
10. Key violation이 발생했을 때
'Key violation.'#$D#$A'ORA-00001: unique constraint (KJPRDDBA.TEMPPrimaryKey1)
violated'
Key violation.
ORA-00001: unique constraint (KJPRDDBA.TEMPPrimaryKey1) violated
11. 숫자 필드에 문자를 넣었을 때
'General SQL error.'#$D#$A'ORA-01722: invalid number'
General SQL error.
ORA-01722: invalid number
참고: oerr ora 7122 과 같이 입력하면 오라클 에러코드 책을
찾지 않아도 설명을 볼 수 있습니다
|