1627: -- bug 3296747 forgot the else ...
1628: l_name := upper(p_name);
1629: end if;
1630:
1631: delete ICX_SESSION_ATTRIBUTES
1632: where SESSION_ID = p_session_id
1633: and NAME = l_name;
1634:
1635: insert into ICX_SESSION_ATTRIBUTES
1631: delete ICX_SESSION_ATTRIBUTES
1632: where SESSION_ID = p_session_id
1633: and NAME = l_name;
1634:
1635: insert into ICX_SESSION_ATTRIBUTES
1636: (SESSION_ID,NAME,VALUE)
1637: values
1638: (p_session_id,l_name,p_value);
1639: commit;
1661: end if;
1662:
1663: select VALUE
1664: into l_value
1665: from ICX_SESSION_ATTRIBUTES
1666: where SESSION_ID = p_session_id
1667: and NAME = l_name;
1668:
1669: return l_value;
1693: -- bug 3296747 forgot the else ...
1694: l_name := upper(p_name);
1695: end if;
1696:
1697: delete ICX_SESSION_ATTRIBUTES
1698: where SESSION_ID = p_session_id
1699: and NAME = l_name;
1700:
1701: -- Fix for bug#5326396 -- Added a commit and exception handling to the code.