Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set session state

513470May 18 2006 — edited May 19 2006
Hi!

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2006
Added on May 18 2006
2 comments
406 views