Re: 7.3.4 External Procedure Call

I don't know what the "pipes" discussion is getting at, but no, external calls are not supported prior to Oracle8. You can, however, use the dbms_file functionality. Perhaps you can create a named pipe at the os level and write to it, and another from which to read.

Oracle pipes are altogether different. They are meant for inter-session communications. Although O8 has a new Advanced Queuing feature, this is a persistent messaging facility and does not replace Oracle pipes. Don't look for Oracle pipes to go away any time soon. And no, Oracle pipes are not particularly resource intensive. They are fast and efficient, faster than RPC in fact.

Roger Snowden
rsnowden_at_us.oracle.com

Pete Simpson wrote:
>
> Is there a better way to do it than pipes? From what I've been told,
> pipes are VERY resource intensive, and Oracle is not going to support
> pipes applications in the very near future. Plus, pipes require an
> application to be sitting on the system, polling the pipe to see if
> there is data there -- again this sounds resource intensive. It'd be
> better it when there was work to do I could just make a fn call.
>
> Pete
>
> MotoX <rat_at_tat.a-tat.com> wrote:
> > Look at 'pipes' in the Application Developers Guide.
>
> > Pete Simpson wrote in message ...
> >>7.3.4. Does anyone know if "external procedure calls" are supported in
Received on Tue Sep 01 1998 - 09:11:04 CDT