| iKnowBase | |||||
SUMMARY: FIELD | TYPE | METHOD | DETAIL: FIELD | TYPE | METHOD |
Field Summary | |
VARCHAR2(63) | QUEUE_NAME CONSTANT := UPPER(IKB_GLOBAL_PREFS.PROVIDER_SCHEMA) || '.IKB_FUNCTIONS_Q'
Oracle AQ queue name |
NUMBER(10,0) | DEFAULT_PRIORITY CONSTANT := 4
Default priority number if not explicitly set. |
NUMBER(10,0) | DEFAULT_TTLSECONDS CONSTANT := 86400
Default time-to-live in seconds for the enqueued request if not explicitly set. |
NUMBER(10,0) | DEFAULT_MAX_WAIT_SECONDS CONSTANT := 60
Default max number of seconds to wait for a response if not explicitly set. |
Method Summary | |
|
CLEANUP(P_MAX_AGE_DAYS IN INTEGER)
Cleanup procedure deleting all records older than the specified number of days |
RAW |
SUBMIT(FUNCTIONNAME IN VARCHAR2, INPUT IN CLOB, SERVICENAME IN VARCHAR2 DEFAULT NULL, PRIORITY IN NUMBER DEFAULT DEFAULT_PRIORITY, TTLSECONDS IN BINARY_INTEGER DEFAULT DEFAULT_TTLSECONDS)
Submit a job for processing at a later time (but "as soon as possible"). |
RAW |
SUBMIT(REQUEST IN CLOB)
Submit a job for processing at a later time (but "as soon as possible"). |
CLOB |
SUBMIT_AND_WAIT_FOR_RESPONSE(FUNCTIONNAME IN VARCHAR2, INPUT IN CLOB, SERVICENAME IN VARCHAR2 DEFAULT NULL, PRIORITY IN NUMBER DEFAULT DEFAULT_PRIORITY, TTLSECONDS IN BINARY_INTEGER DEFAULT DEFAULT_TTLSECONDS, MAX_WAIT_SECONDS IN NUMBER DEFAULT DEFAULT_MAX_WAIT_SECONDS)
Submit a job for processing at a later time (but "as soon as possible") and wait |
CLOB |
SUBMIT_AND_WAIT_FOR_RESPONSE(REQUEST IN CLOB, MAX_WAIT_SECONDS IN NUMBER DEFAULT DEFAULT_MAX_WAIT_SECONDS)
Submit a job for processing at a later time (but "as soon as possible") and wait |
Field Detail |
public NUMBER(10,0) DEFAULT_MAX_WAIT_SECONDS CONSTANT := 60
public NUMBER(10,0) DEFAULT_PRIORITY CONSTANT := 4
public NUMBER(10,0) DEFAULT_TTLSECONDS CONSTANT := 86400
public VARCHAR2(63) QUEUE_NAME CONSTANT := UPPER(IKB_GLOBAL_PREFS.PROVIDER_SCHEMA) || '.IKB_FUNCTIONS_Q'
Method Detail |
public CLEANUP(P_MAX_AGE_DAYS IN INTEGER)
P_MAX_AGE_DAYS
-
Number of days to keep / remove logs older than p_max_age_days.public RAW SUBMIT(FUNCTIONNAME IN VARCHAR2,
INPUT IN CLOB,
SERVICENAME IN VARCHAR2 DEFAULT NULL,
PRIORITY IN NUMBER DEFAULT DEFAULT_PRIORITY,
TTLSECONDS IN BINARY_INTEGER DEFAULT DEFAULT_TTLSECONDS)
FUNCTIONNAME
-
Name of the function to execute.INPUT
-
Map of input parameters.SERVICENAME
-
Optional service name used to select one or more specific function servers.PRIORITY
-
Optional priority number for the queued messages. Lower number has higher priority.TTLSECONDS
-
Optional time to live in seconds for the request message.public RAW SUBMIT(REQUEST IN CLOB)
REQUEST
-
JSON-formatted execution requestpublic CLOB SUBMIT_AND_WAIT_FOR_RESPONSE(FUNCTIONNAME IN VARCHAR2,
INPUT IN CLOB,
SERVICENAME IN VARCHAR2 DEFAULT NULL,
PRIORITY IN NUMBER DEFAULT DEFAULT_PRIORITY,
TTLSECONDS IN BINARY_INTEGER DEFAULT DEFAULT_TTLSECONDS,
MAX_WAIT_SECONDS IN NUMBER DEFAULT DEFAULT_MAX_WAIT_SECONDS)
FUNCTIONNAME
-
Name of the function to execute.INPUT
-
Map of input parameters.PRIORITY
-
Optional priority number for the queued messages. Lower number has higher priority.TTLSECONDS
-
Optional time to live in seconds for the request message.public CLOB SUBMIT_AND_WAIT_FOR_RESPONSE(REQUEST IN CLOB,
MAX_WAIT_SECONDS IN NUMBER DEFAULT DEFAULT_MAX_WAIT_SECONDS)
REQUEST
-
JSON-formatted execution request
| iKnowBase | |||||
SUMMARY: FIELD | TYPE | METHOD | DETAIL: FIELD | TYPE | METHOD |