How could I open a C program from PL/SQL code?

[jcasas23]

I need to open a C program file with parameters from a PL/SQL program. How could I do this?
For example this is my C program main:

main(argc, argv)
int argc;
char *argv[];
{ *** code typing using parameters ***
}

Is there a way to convert C program in a external procedure using PL/SQL or Is ther a way to make a dll that C program to using in PL/SQL like a function?

thanks in advance

 

[dsanchez2]

You should be able to do this by a "External Subprogram". This facility allows you to call routines written in another language, such as C. So you could write a C function that invokes your program, and call this function from PL/SQL. See the "Oracle9i Application Developer's Guide - Fundamentals" for information on how to do this.

Another way of doing this is by having a Java stored-procedure and using it to invoke your program.