Re: Call C++ exe from sqlplus

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 22 May 2001 06:34:36 +0200
Message-ID: <tgjqur41n38m27@beta-news.demon.nl>

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B09BE68.E583461E_at_exesolutions.com...
> Sonja Barton wrote:
>
> > I've written a c++ program to handle "name mangling" of document names.
It
> > also handles name collisions.
> >
> > Now, how to call the program from my sql script? I'm returning a text
file
> > which contains a list of the new names to be used in the rest of the sql
> > script.
> >
> > Thanks,
> > sonja
>
> Look at DBMS_PIPE.
>
> Daniel A. Morgan
>

In Oracle 8.0 and higher make sure it's a DLL and look at the external procedure mechanism.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon May 21 2001 - 23:34:36 CDT