set session state
513470May 18 2006 — edited May 19 2006Hi!
I have an application, where users can log in either from the login page or they can come from an other application (not written in appexp), and in this case we want to use single sign on and put a button on every page: return to the other application.
I created an application item to store the return address (link).
I created a stored procedure,which gets the parameters from the url, calls the login procedure and want to set the session state. It is like this:
create or replace procedure "TEST_LOGIN"(p_return_address in varchar2,
p_uname IN VARCHAR2,
p_password IN VARCHAR2,p_session_id IN VARCHAR2,
p_app_page IN VARCHAR2)
is
begin
htmldb_custom_auth.login(p_uname, p_password, p_session_id, p_app_page);
if htmldb_custom_auth.session_id_exists = true then
htmldb_util.set_session_state('F110_RETURN_ADDRESS', p_return_address);
end if; --if the login was correct, set the application item
end;
But I get the error:
Error ERR-1002 Unable to find item ID for item "F110_RETURN_ADDRESS" in application "".
Can anyone tell me, how to set the value of an item in this case?
Regards,
Petra