|
##########################################################
SQL Error
Error while trying to retrieve text for error ORA-03114
in " INSERT INTO client(ID,name) VALUES('test','test') "
on line 71 in file client_enroll.pc
현재까지 실행된 SQL문의 개수: 0
#########################################################
이런 에러가 나네요...오라클에서 oerr인가 쳐서 에러코드
설명나온다는데 그것도 안 나오는 거라서...-_-
다음은 소스의 메인 부분임다.
#########################################################
48 DB_Task()
49 {
50
51 strcpy(dbuid.arr, USERID); dbuid.len = strlen(USERID);
52 strcpy(dbpwd.arr, PASSWD); dbpwd.len = strlen(PASSWD);
53
54 EXEC SQL CONNECT :dbuid IDENTIFIED BY :dbpwd;
55 EXEC SQL WHENEVER SQLERROR DO error_out("SQL Error");
56
57 oraca.orastxtf = ORASTFERR;
58
59 /* 각 form의 input text에 있는 내용을 호스트 변수에
복사 */
60 strcpy(id.arr, strValue(cgi_input[0]));
61 id.len = strlen(strValue(cgi_input[0]));
62 strcpy(passwd.arr, strValue(cgi_input[1]));
63 passwd.len = strlen(strValue(cgi_input[1]));
64 strcpy(name.arr, strValue(cgi_input[2]));
65 name.len = strlen(strValue(cgi_input[2]));
66 strcpy(phone.arr, strValue(cgi_input[3]));
67 phone.len = strlen(strValue(cgi_input[3]));
68 strcpy(address.arr, strValue(cgi_input[4]));
69 address.len = strlen(strValue(cgi_input[4]));
70
71 EXEC SQL EXECUTE IMMEDIATE "INSERT INTO client(ID,name
) VALUES('
test','test')";
72
73 EXEC SQL COMMIT WORK RELEASE;
74
75 return 0;
76 }
############################################################
돠주세여~~
|
