ORA-01036: illegal variable name/number

From: chandrika h via DBMonster.com <forum_at_DBMonster.com>
Date: Fri, 12 Aug 2005 10:47:26 GMT
Message-ID: <52BA56E475B38@DBMonster.com>

Sir,
Please any one can help me about this error.I have gone through internet but i couldn't get solution for this
error.Actually i am calling a sql procedure in c++ and i am getting this error.I am not able to rectify this error from past three days pls any one can help me abt this.I am embedding procedure like this.

ProcReturnType DBProc_Receive_validate_boxid_duplication(char* box)
{

  ProcReturnType ProcReturn;
  boolean retStatus = FALSE;
  char p_msg[120];
  ProcReturn.Status = FALSE;
  char localRet[120];  

  GlbOracleErrorFlag = FALSE;     

{

  struct sqlexd sqlstm;

  sqlstm.sqlvsn = 12;
  sqlstm.arrsiz = 13;
  sqlstm.sqladtp = &sqladt;
  sqlstm.sqltdsp = &sqltds;
  sqlstm.stmt = "declare localRet BOOLEAN ; BEGIN PRF01 .

CHECK_FOR_BOXID_DUPLICATION( :GlbC\
omId , :box , localRet , p_msg ) ; IF ( localRet\  ) THEN :retStatus := 1 ; END IF ; END ;";

  sqlstm.iters = (unsigned int  )1;
  sqlstm.offset = (unsigned int  )1521;
  sqlstm.cud = sqlcud0;
  sqlstm.sqlest = (unsigned char  *)&sqlca;
  sqlstm.sqlety = (unsigned short)256;
  sqlstm.occurs = (unsigned int  )0;
  sqlstm.sqhstv[0] = (unsigned char  *)GlbComId;
  sqlstm.sqhstl[0] = (unsigned long )0;
  sqlstm.sqhsts[0] = (         int  )0;
  sqlstm.sqindv[0] = (         short *)0;
  sqlstm.sqinds[0] = (         int  )0;
  sqlstm.sqharm[0] = (unsigned long )0;
  sqlstm.sqadto[0] = (unsigned short )0;
  sqlstm.sqtdso[0] = (unsigned short )0;
  sqlstm.sqhstv[1] = (unsigned char  *)box;
  sqlstm.sqhstl[1] = (unsigned long )0;
  sqlstm.sqhsts[1] = (         int  )0;
  sqlstm.sqindv[1] = (         short *)0;
  sqlstm.sqinds[1] = (         int  )0;
  sqlstm.sqharm[1] = (unsigned long )0;
  sqlstm.sqadto[1] = (unsigned short )0;
  sqlstm.sqtdso[1] = (unsigned short )0;
  sqlstm.sqhstv[2] = (unsigned char  *)p_msg;
  sqlstm.sqhstl[2] = (unsigned long )1002;
  sqlstm.sqhsts[2] = (         int  )0;
  sqlstm.sqhstv[3] = (unsigned char  *)&retStatus;
  sqlstm.sqhstl[3] = (unsigned long )sizeof(int);
  sqlstm.sqhsts[3] = (         int  )0;
  sqlstm.sqindv[3] = (         short *)0;
  sqlstm.sqinds[3] = (         int  )0;
  sqlstm.sqharm[3] = (unsigned long )0;
  sqlstm.sqadto[3] = (unsigned short )0;
  sqlstm.sqtdso[3] = (unsigned short )0;
  sqlstm.sqphsv = sqlstm.sqhstv;
  sqlstm.sqphsl = sqlstm.sqhstl;
  sqlstm.sqphss = sqlstm.sqhsts;
  sqlstm.sqpind = sqlstm.sqindv;
  sqlstm.sqpins = sqlstm.sqinds;
  sqlstm.sqparm = sqlstm.sqharm;
  sqlstm.sqparc = sqlstm.sqharc;
  sqlstm.sqpadto = sqlstm.sqadto;
  sqlstm.sqptdso = sqlstm.sqtdso;

  sqlcxt((void **)0, &sqlctx, &sqlstm, &sqlfpn);   if (sqlca.sqlcode < 0) sql_error("ORACLE error--\n"); }        

  SET_RETURN_STATUS();
  if (GlbLogStatus==TRUE)
  {
    char LogBuf[1500];
    sprintf(LogBuf,"PRF01.check_for_boxid_duplication(%s,%s,%s,%s)", GlbComId, box,localRet,p_msg);

    Log(LogBuf);
  }

  ERROR_HANDLER();
  return(ProcReturn);
} Received on Fri Aug 12 2005 - 05:47:26 CDT