Re: Piping data out of PL/SQL ?

In <MLOENNRO.93Oct8005938_at_wrpyr4.us.oracle.com> mloennro_at_us.oracle.com (Magnus Lonnroth) writes:

>If you want to...
 

>Write back to the client application (sqlplus, sqlforms, etc),
>please review the DBMS_OUTPUT package.
 

>Pipe output to any client application (even on a different node),
>please review the DBMS_PIPE package.
 

>Pipe output to multiple client applications,
>please review the DBMS_ALERT package.
 

>Send an Oracle*Mail message,
>please review the DBMS_MAIL package.

But what about:

Pipe output to any host process on any node (tricky, I'll grant you), please review ???

Pipe output to any host process local to server-side, please review ???

Pipe output to any host process local to client-side, (surely the most

        common reqt of the eight!?)
please review ???

Pipe output from server to any host process client-side, (quite tricky

        also, DBMS-pipes would cut the mustard here if we had #7) please review ???

>happy piping,

If only. I always need 5, 6, 7 or 8.

Informix can do it (client-side & sort-of server-side). Unify can do it (client-side only I think). Sybase I suspect can do it (both sides?) Don't know about Ingres (probably can't)

Why not Oracle?

and don't say user-exits, what a pain in the a***!

>Magnus Lonnroth
>Oracle Sweden
 

>[My opinions are not supported]

Nor are the bits you left out, unfortunately.

graeme

--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.