Hi everyone, I have a function on DB with code below as:
begin
-- Call the function
:result := WFL_PKG.Check_Validate_Action(P_TRAN_ID => :P_TRAN_ID,
P_User_Name => :P_User_Name,
P_Action_Type => :P_Action_Type,
P_DAYS => :P_DAYS);
end;
When I test it by my parameter, it returns 'TRUE'. It is right for me. But when I check it on the web with the same parameter, it returns FALSE.
Now I see when P_DAYS is interger like 1.0, 2.0, 3.0,.. DB and web return same value, when P_DAYS is float like 0.5, 1.5,... DB returns right value while web return false value. I use the function on server-side condition and I test many type of server-side condition, it still has wrong value. Anyone can suggest me to solve that problem?
Huy NguyenProfessional
Check function on the web of oracle apex is not working
2 Answers
You must login to add an answer.
Vinish Kapoor
If you are using this PL/SQL code then are you submitting the page items you have used to call the function? If not then specify it.
Also, try to get the result in a variable and then compare it. Below is an example:
declare result boolean; begin -- Call the function result := WFL_PKG.Check_Validate_Action(P_TRAN_ID => :P_TRAN_ID, P_User_Name => :P_User_Name, P_Action_Type => :P_Action_Type, P_DAYS => :P_DAYS); if result then -- do something if true else -- do something if false end if; end;Huy Nguyen
Thank for your idea. But that function I return varchar2, can not to change type. So I can't check your function in my apps. I test that select statement
select 0.5 from dual;
On Db, it returns 0.5 while on oracle apex returns .5. I think the problem starts from here.