php에서 프로시져 연동을 할려구 하는데 사용하면 이런 에러가 나네여..왜 그런지 갈켜 주세요.
Warning: OCIStmtExecute: ORA-06550: line 1, column 324: PLS-00103: Encountered the symbol ")" when expecting one of the following: ( - + mod not null others avg count current exists max min prior sql stddev sum variance execute forall time timestamp interval date in /home/htdocs/urii/its/member/member_insert.html on line 171
소스는
$procedure = "begin ";
$procedure .= " WEB_CUST_INSERT ( ";
$procedure .= " '$ppCustName', '$ppUserID', ";
$procedure .= " '$ppPassWord', '$ppSex', ";
$procedure .= " '$ppJuMin', '$ppTel1', ";
$procedure .= " '$ppTel2', '$ppTel3', ";
$procedure .= " '$ppHp1', '$ppHp2', ";
$procedure .= " '$ppHp3', '$ppEmail', ";
$procedure .= " '$ppZip', '$ppZipSEQ', ";
$procedure .= " '$ppAddr', '$ppSMSYN', ";
$procedure .= " '$ppMailYN', '$ppPOSTYN', ";
$procedure .= " '$ppInLine', '$ppCrDate', ";
$procedure .= " '$ppHospInfo', '$ppBoy1Name', ";
$procedure .= " '$ppBoy1Sex', '$ppBoy1Birth', ";
$procedure .= " '$ppBoy1Moon', '$ppBoy2Name', ";
$procedure .= " '$ppBoy2Sex', '$ppBoy2Birth', ";
$procedure .= " '$ppBoy2Moon', '$ppBoy3Name', ";
$procedure .= " '$ppBoy3Sex', '$ppBoy3Birth', ";
$procedure .= " '$ppBoy3Moon', '$ppBoyHospInfo', ";
$procedure .= " '$ppBirth', '$ppMoon', ";
$procedure .= " '$ppMariDate', '$ppLivFlag', ";
$procedure .= " '$ppSchool', '$ppJob', ";
$procedure .= " '$ppPay', '$ppBreeder', ";
$procedure .= " '$ppdouble', '$ppHowCom', ";
$procedure .= " '$ppCustNo', '$ppBaeSEQ', ";
$procedure .= " )";
$procedure .= " end;";
$stmt = ociparse ($connect, $procedure);
ociexecute ($stmt);
ocifreestatement ($stmt);
이거 입니다.
왜 그런지 명확히 좀 갈켜 주세요..급하거든요...부탁 드립니다.
그럼.
|