Re: Calling a Programm from a stored Procedure

From: <mconnors_at_mother.com>
Date: 1997/09/24
Message-ID: <01bcc8ac$29198640$a52168cf_at_mconnors.mother.com>#1/1

The short answer is no in Oracle7. You can in Oracle8. In 7, there are several things you can do to get around this, the most popular probably being using a database pipe and Pro*C daemon. In the stored procedure, put a message on the pipe. The daemon checks the pipe, and being Pro*C, can run the program. If need be, it can use the pipe to send a message back to the PL/SQL procedure.

-- 
Regards,
Matt Connors

Joe <josef.huber_at_ennstal.at> wrote in article
<01bcc4ff$27db9da0$019a70c2_at_AnonymousIPX>...


> Hi,

> Is it possible to call a Programm from a stored Procedure.

> 

> System: Oracle Workgroupserver 7.3.2 Windows NT 4.0

Received on Wed Sep 24 1997 - 00:00:00 CEST

This message: [ Message body ]
Next message: Sylvain Robitaille: "A question about Power Object..."
Previous message: Brett Neumeier: "Re: New appearance of errors on SQL Plus on connect..."
In reply to: Joe: "Calling a Programm from a stored Procedure"
Next in thread: Jomarlen: "Re: Link with WINHELP"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message