Yes, using DBMS_PIPE is one of the method.
U can write a package which include some procedures or
functions that can be used all the time.
Somthing like:
turn_pipe_on;
turn_pipe_off;
put_line_proc();
get_line_proc();
By using DBMS_PIPE does impact the performance, so use it
carefully.




Reply With Quote