마지막 )옆에 세미콜론 ';'이 빠졌네요..
이것 없으면 )에서 다음 문장을 찾을수 없다(?) 맞는 메시지인지는 모르겠지만
비슷한 에러가 납니다.
잘 보시면 그곳이 빠졌어요..
$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 .= " );";이렇게 쓰세요
>>까투리 님께서 쓰시길<<
:: php에서 프로시져 연동을 할려구 하는데 사용하면 이런 에러가 나네여..왜 그런지 갈켜 주세요.
::
:: Warning: OCIStmtExecute: ORA-06550: line 1, column 324: PLS-00103: Encountered the symbol ")" wh
:: en expecting one of the following: ( - + mod not null others avg count current exists max min pr
:: ior 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);
::
:: 이거 입니다.
::
:: 왜 그런지 명확히 좀 갈켜 주세요..급하거든요...부탁 드립니다.
:: 그럼.
|