Re: OS Commands from PL/SQL?

Use the Oracle Jserver.

Jim Harrison <jim_at_colway.freeserve.co.uk> wrote in message news:8ev7b0$d3t$1_at_news6.svr.pol.co.uk...
> 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 Sun May 07 2000 - 00:00:00 CDT