Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Arguments Source

CREATE_PXT_SESSION

DDL script

Arguments:

NameData TypeDefault ValueIn/Out
WEB_USER_IDNUMBER(38) IN
EXPIRESNUMBER(38) IN
VALUEVARCHAR2 IN

Returns:

NUMBER(38)

Source

Legend: comment string keyword reserved word operator
     1: function
     2: create_pxt_session(web_user_id in number, expires in number, value in varchar)
     3: return number
     4: is
     5: pragma autonomous_transaction;
     6: 	id number;
     7: begin
     8: 	select
     9: 		pxt_id_seq.nextval into id
    10: 	from
    11: 		dual;
    12: 
    13: 	insert into PXTSessions (id, value, expires, web_user_id)
    14: 	values (id, value, expires, web_user_id);
    15: 	commit;
    16: 
    17: 	return id;
    18: end;