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

Home -> Community -> Usenet -> c.d.o.tools -> Re: OS Commands from PL/SQL?

Re: OS Commands from PL/SQL?

From: Jim Harrison <jim_at_colway.freeserve.co.uk>
Date: 2000/05/05
Message-ID: <8ev7b0$d3t$1@news6.svr.pol.co.uk>#1/1

Oracle 8 allows you to exec a C program from PL/SQL. You can check the Oracle documentation for implementation. Your C program could look something like this...

#include <stdio.h>
#include <stdlib.h>

int main (int argc, char **argv)
{

    if (argc == 1)
    {

        system(argv[1]);
    }
 return EXIT_SUCCESS;
}
A bit more error handling would be nice, but you get the general idea.

--
Jim Harrison
Colway Software and Design
www.colway.freeserve.co.uk
Received on Fri May 05 2000 - 00:00:00 CDT

Original text of this message

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