Use SELECT inside an IF statement

Question

I want a query like this:

 if ((select closedatetime from tbl_eventschedularmaster where eventid=p_EventId)> sysdate)
 then
     update tbL_ANSWERMASTER set AnsText=p_AnsText
      where AnsId=p_checkduplicate RETURNING AnsId INTO p_ReturnVal;
else 
      RETURNING 0 INTO p_ReturnVal;
 end if

but it is not working

Error(29,15): PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + case mod new not null continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe — Ketan mevada, Jan 03 '15 at 14:20

score 2 · Answer 1 · answered Jan 03 '15 at 15:50

You'll need to re-write that as

select closedatetime
  into dtClosedDateTime
  from tbl_eventschedularmaster
  where eventid = p_EventId;

if dtClosedDateTime > sysdate then
  update tbL_ANSWERMASTER
    set AnsText=p_AnsText
    where AnsId=p_checkduplicate
    RETURNING AnsId INTO p_ReturnVal;
else 
  p_ReturnVal := 0;
end if;

Share and enjoy.

Use SELECT inside an IF statement

1 Answers1