TOraStoredProc problem

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Danilkak

TOraStoredProc problem

Post by Danilkak » 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.

Danilkak

Post by Danilkak » Wed 09 Mar 2005 16:16

Sorry. I use Delphi 7 and Oracle 9.2.0.6

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Thu 10 Mar 2005 10:29

We couldn't reproduce your problem, pls. specify your Oracle client and ODAC versions and if it possible send us small demo project with scripts to create server side objects.

Danilkak

Post by Danilkak » Thu 10 Mar 2005 12:33

Sorry, it's was Oracle error

Post Reply