CREATE OR REPLACE MODULE sessions.service;
ALTER MODULE sessions.service
PUBLISH TYPE property_object AS ROW
(
property_id VARCHAR(200),
object BLOB(2097152)
);
ALTER MODULE sessions.service
PUBLISH TYPE property_object_array AS property_object ARRAY[];
ALTER MODULE sessions.service
PUBLISH PROCEDURE save_session
(
p_session_id VARCHAR(60),
p_principal_name VARCHAR(120),
p_max_inactive_seconds INTEGER,
p_property_objects property_object_array
);
ALTER MODULE sessions.service
PUBLISH PROCEDURE get_session
(
p_session_id VARCHAR(60),
OUT p_principal_name VARCHAR(120),
OUT p_max_inactive_seconds INTEGER,
OUT p_property_objects property_object_array
);
ALTER MODULE sessions.service
PUBLISH PROCEDURE delete_session(p_session_id VARCHAR(60));