Function call in a pl-sql block

[Thiko]

I have this function and I would like to call it in a pl-sql block in a script to see if the userid is in the permissions table, which is what the function does. How do I call this procedure in a pl-sql block?

CREATE OR REPLACE PACKAGE BODY dba_services AS
FUNCTION permissions (current_user IN VARCHAR2) RETURN NUMBER
IS
result NUMBER;
result2 NUMBER;
BEGIN
SELECT COUNT(user_id) INTO result FROM dba_users
WHERE username = current_user;
IF result > 0 THEN
SELECT user_id INTO result FROM dba_users
WHERE username = current_user;
END IF;
SELECT count(userid) INTO result2 FROM permissions
WHERE userid = result;
IF result2 > 0 THEN
SELECT userid INTO result2 FROM permissions
WHERE userid = result;
END IF;
RETURN result2;
END permissions;
Many Thanks.

Thiko!

 

[Kenrae]

Err, well

 result:=dba_services.permissions(user)

should work. Is that what you were asking for?

If you want to use real user, you can have it by doing

 SELECT user FROM dual;