| not equal- != or <> [message #37692] |
Thu, 21 February 2002 08:24  |
Jeff Lassen
Messages: 2
Registered: February 2002
|
Junior Member |
|
|
I have been getting variable results with != within a number of ORACLE procedures I have written. I can't seem to find a pattern to when it doesn't work. Do I need to change all occurrences of != to <>, or are there some specific types of uses for which it will not work.
Current example:
IF v_mins_done != 'T'
THEN
v_mins_appl_priv_other := '1';
v_mins_done := 'T';
END IF;
does not do the desired action when v_mins_done = 'F'.
Thanks for the help!
|
|
|
|
| Re: not equal- != or <> [message #37693 is a reply to message #37692] |
Thu, 21 February 2002 11:09  |
Jon
Messages: 483
Registered: May 2001
|
Senior Member |
|
|
It works for me. What is the datatype of v_mins_done?
16:04:03 ==> declare
16:07:51 2 v_mins_done varchar2(1) := 'F';
16:07:51 3 begin
16:07:51 4 if v_mins_done != 'T' THEN
16:07:51 5 dbms_output.put_line ('!= worked');
16:07:51 6 else
16:07:51 7 dbms_output.put_line ('!= did not work');
16:07:51 8 end if;
16:07:51 9 end;
16:07:52 10 /
!= worked
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
