Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01036: illegal variable name/number

Re: ORA-01036: illegal variable name/number

From: Noel <tbal_at_go2.pll-l>
Date: Fri, 12 Aug 2005 15:55:30 +0200
Message-ID: <ddia2e$n4b$1@inews.gazeta.pl>


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;
> sqlstm.offset = (unsigned int )1521;
> sqlstm.cud = sqlcud0;
-- 
TomekB tbal_at_go2.pl-l
Received on Fri Aug 12 2005 - 08:55:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US