Re: ORA-01036: illegal variable name/number

Użytkownik chandrika h via DBMonster.com napisał:

> 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\

                           ^^^^^^^^^ <- missing ':' before p_msg?



>  ) THEN :retStatus := 1 ; END IF ; END ;";

           ^^^^^^^^^^ <- its BOOLEAN type, shouldn't be assigned TRUE?




>   sqlstm.iters = (unsigned int  )1;

-- 
TomekB tbal_at_go2.pl-l