DBMS_PIPE.PACK_MESSAGE(something), where something is NUMBER, VARCHAR2, DATE, RAW, ROWID
DBMS_PIPE.SEND_MESSAGE(pipename), where pipename is VARCHAR2, function returns 0 - successful, otherwise - error code.
DBMS_PIPE.RECEIVE_MESSAGE(pipename)
DBMS_PIPE.UNPACK_MESSAGE(something)
The order of unpack should be the same as the pack order. And data types too.
Another functions:
DBMS_PIPE.NEXT_ITEM_TYPE, returns 9 for VARCHAR2, 12 for DATE, etc.
DBMS_PIPE.PURGE(pipename), empties pipe
No comments:
Post a Comment