CREATE_PXT_SESSION
DDL scriptArguments:
Name | Data Type | Default Value | In/Out |
---|
WEB_USER_ID | NUMBER(38) | | IN |
EXPIRES | NUMBER(38) | | IN |
VALUE | VARCHAR2 | | IN |
Returns:
NUMBER(38)Source
Legend: 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;