Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Calling 'C' from PL/SQL

Re: Calling 'C' from PL/SQL

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1997/10/30
Message-ID: <3458b1f1.64863558@newshost>#1/1

In 7.x this is accomplished via the use of dbms_pipes. The server application developers guide has an example. As well, you might want to look at plex available on http://govt.us.oracle.com under downloadable utilities. It simply automates any code you would have to write to call C from pl/sql.

In 8.x, this is done via external procedures, procedures written in some other language (other then pl/sql) and run by the database.

On Thu, 30 Oct 1997 08:13:52 -0500, Mike Rowland <102622.2522_at_CompuServe.COM> wrote:

>Does anyone out there know how to call a 'C' routine
>from PL/SQL?
>
 

>We are running Oracle 7.3.3 PS on an AIX 4.1.5 platform, and
>using Oracle procedure builder to build stored procedures. Some
>of our developers want to incorporate some 'C' routines that are
>already built. Typically, I've done the reverse (calling PL/SQL
>from 'C') but they want to keep things consistent with what they
>have already developed.
>
 

>Thanks in Advance,
>Mike Rowland
>MRowland1_at_compuserve.com
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  



Opinions are mine and do not necessarily reflect those of Oracle Corporation  

NOTICE: In order to cut down on the amount of time I spend applying silly logic to email addresses like "In order to cut down on spam, remove THIS from my email" or "In order to cut down on spam, reverse my email address", etc, I will simply hit delete when that mail bounces back to me, which is what I do with spam myself.  

I haven't figured out whats more time consuming for me, deleting spam or resending emails after re-reading the whole thing to figure out the algorithm to apply. Received on Thu Oct 30 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US