Oracle

! = ''

In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement to NOT TRUE and skips onto the next 'IF' satement whereas I would have thought that it would have equated to TRUE and carried on to execute the store_time function which is what I want it to do.

Can someone please explain why this is happening ?

IF (v_ompcat != 'OD' OR v_ompcat != '') THEN
BEGIN
store_time(v_tstamp,
'mo_vements',
'mo_1st_arr_time',
v_incno);
END;
END IF;
IF (v_colname = 'mb_leave') THEN
BEGIN
Advertisement

0 answers

No answers posted yet. Be the first to answer.

Your answer

Login to answer

Trending today: see what people are reading