node-oracle icon indicating copy to clipboard operation
node-oracle copied to clipboard

AdvancedQueue

Open snaveenkumareee opened this issue 11 years ago • 3 comments

we have to dequeue the Advanced queues in oracle for processing the events. can we implement dequeuing code using this module

snaveenkumareee avatar Jun 30 '14 06:06 snaveenkumareee

Sure, with this module you may call pl/sql procedures, use dbms_aq packaage calls.

fuson avatar Jul 12 '14 16:07 fuson

Thanks for the update. I was trying to use oracle udt for the queue payload. Does this module support udt's

snaveenkumareee avatar Jul 12 '14 16:07 snaveenkumareee

Unfortunately no, but you may pass simple data types (varchar number etc) and construct udt on stored procedure side.

fuson avatar Jul 12 '14 17:07 fuson