Gurus,
I went thro all the stuff that you guys suggested....
Now I have one possiblilty ...Please could you tell me if this is gonna be good enough...
Oracle can do file reading and writing....which C can also do.
Lets say Oracle stores these parameters in a file called vdata100.txt
Oracle can also read the file vdataresult100.txt.
But since I cannot hard code these parameters, I have to pass them to C as variables....
Oracle will call the C function and pass the parameter v_infile, v_outfile which are the names of the txts...
Oracle says:
Code:
tmp = ...(C,datasubmit.c, ...)
register.invar = v_infile // param1
register invar = v_outfile // param1
Can my C function look like this
Code:
databasubmit.c
int send_info(var_infile, var_outfile)
{
fp = fopen(var_infile)
----
write (var_outfile )
return 0 for sucess / failure
}
/* NO MAIN FUNCTION....... */
Just compile it but dont link and create a DLL...and give to oracle...
All this is in VC7
Will this datasubmit.c work?....
thanks a bunch