Hi Friends,
I'm new to oracle. I have a IF condition that checks if the variable is not equal to empty. But the condition fails even if the variable has its value. I have added the part of the code below.
v_MyTestVar := 'Success!' ;
IF v_MyTestVar <> '' THEN
DBMS_OUTPUT.PUT_LINE('v_MyTestVar IS NOT EQUAL TO NULL');
END IF;
Please anyone help me with the solution for this problem.
Thanks,
Ram