PL/SQL (MOSC)

MOSC Banner

Problem using dbms_pipe in trigger

edited Aug 3, 2016 9:41AM in PL/SQL (MOSC) 4 commentsAnswered ✓

I have a problem using pipes in my database. I have a table which gets updated quite rapidly.

This table has a trigger which does an update on another table. This table again has a trigger which

generates a string that is put on a named pipe. Each call to the trigger does a pack_message and then a send_message.

I have seen some indications in my app that consumes the pipe data, where the messages might get garbled on the way. Some

messages are composed of two different messages. Some contain a lot of messages. I'm not sure that the app is

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center