Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: OS Commands from PL/SQL?
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.ukReceived on Fri May 05 2000 - 00:00:00 CDT