ORA 1036

[suvinay]

Hello,
I get ORA-1036: illegal variable name/number
when I try the following. Please let me know
what am I doing wrong!

Thanks much.
-- new to DOA

-----------------------------
_newid := 132;
C_SQL := 'select username from user_list where user_id = :req_user_id';
SSOracleQuery.Clear;
SSOracleQuery.DeleteVariables;
SSOracleQuery.SQL.Add(C_SQL);
SSOracleQuery.DeclareVariable('req_user_id',
otInteger);
SSOracleQuery.SetVariable('req_user_id',
_newid);

SSOracleQuery.Execute;
----------------

 

[suvinay]

:0

Please ignore - there was a typo in code.

Thanks