الا خوة الاعزاء بعد التحية ارجو منكم المساعدة وجزاكم اللة خير
المشكلة:اريد معرفة عمل هذه الدالة dbms_session.is_role_set()
علما اني جربتها على developerولكن ما اشتغلت معي وتظهر لي رسالة خطأ ('dbms_session ')non declared
ارجو منكم المساعدة ولكم مني جزيل الشكر والتقدير
اخوكم essam

dear my brother

The procedure name is DBMS_SESSION.SET_ROLE
not
dbms_session.is_role_set

the SET_ROLE procedure enables and disables roles for the current session.
the DBMS_SESSION.SET_ROLE is functionally equivalent to the SET ROLE statement in SQL.

example:

set the password-protected role MYROLE

BEGIN
DBMS_SESSION.SET_ROLE('MYROLE IDENTIFIED BY password');
END;




Dear brother

The procedure name is DBMS_SESSION.SET_ROLE
not
dbms_session.is_role_set

the SET_ROLE procedure enables and disables roles for the current session.
the DBMS_SESSION.SET_ROLE is functionally equivalent to the SET ROLE statement in SQL.

example:

set the password-protected role MYROLE

BEGIN
DBMS_SESSION.SET_ROLE('MYROLE IDENTIFIED BY password');
END;