Pl SQL help, SELECT-INTO statement not assign value on host variable
786985Jul 23 2010 — edited Jul 23 2010I have the table Client with column idClient (integer) and at least 3 clients into the table...
Here is the code:
EXEC SQL BEGIN DECLARE SECTION;
int v_idClient;
short idClientInd;
EXEC SQL END DECLARE SECTION ;
//connect code is here
EXEC SQL SELECT idClient INTO :v_idClient:idClientInd FROM Client
WHERE idClient=1;
if(idClientInd == -1)
cout<<"Not Exist"<<endl;
else
cout<<"Exist"<<endl;
my host variable c_idCLient can't be assigned with value '1'...duno why? same thing for Indicator variable...