TOraStoredProc problem
Posted: Wed 09 Mar 2005 15:31
Hi !
I have package in pl/sql where defined overloaded function
FUNCTION IsRoleGranted(aIdUser INTEGER DEFAULT NULL, aIdRole INTEGER) RETURN BOOLEAN;
FUNCTION IsRoleGranted(aIdUser INTEGER DEFAULT NULL, aIdRole VARCHAR) RETURN BOOLEAN;
when i create component TOraStoredProc and point to call this package function, then component write next code:
declare
v_RESULT boolean;
begin
v_RESULT := auth.AUTH_USERS.ISROLEGRANTED(:AIDROLE,:AIDUSER);
:RESULT := sys.DIUTIL.BOOL_TO_INT(v_RESULT);
end;
Pls note, the order of parameters different from declaration of function.
I have package in pl/sql where defined overloaded function
FUNCTION IsRoleGranted(aIdUser INTEGER DEFAULT NULL, aIdRole INTEGER) RETURN BOOLEAN;
FUNCTION IsRoleGranted(aIdUser INTEGER DEFAULT NULL, aIdRole VARCHAR) RETURN BOOLEAN;
when i create component TOraStoredProc and point to call this package function, then component write next code:
declare
v_RESULT boolean;
begin
v_RESULT := auth.AUTH_USERS.ISROLEGRANTED(:AIDROLE,:AIDUSER);
:RESULT := sys.DIUTIL.BOOL_TO_INT(v_RESULT);
end;
Pls note, the order of parameters different from declaration of function.