Hi Team,
Using Oracle 11g R2.
I have one SP which update records of last 30 hrs. And I am trying to use BIND variables in update statement but getting error message
>> PLS-00049: bad bind variable 'A' >> At compilation time itself.
-------------------------------------------------
v_dt := 1524585391; --This current EPOCH Date and time value (Please refer link: https://www.epochconverter.com/ )
begin
update table_name
set timestamp = :a
where timestamp = 0
and Entry_Dt between :a - 86400*1.2 and :a
using v_dt;
end;
-----------------------------------------
Can you please suggest, what's wrong with this update statement.