My feeling is that, given the clumsy way external procedures are implemented, the argument of C speed doesn't hold too well. If you must write a function which will be called through IPCs each time you return a row, from instance, C will look javaish in speed. Add to this that static variables cannot be relied upon because the function can be reloaded anytime, that you have to be very careful about the really fun C stuff for fear of interference with Oracle (signals, etc.) - My feeling is that external C functions have no real practical use. If speed is a concern (and it often is) it should be C which calls Oracle, not the reverse.
My EUR 0.02 Stephane Faroult >----- ------- Original Message ------- ----- >From: Jared Still <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Thu, 04 Sep 2003 15:49:26 > >Or Perl... > >On Thu, 2003-09-04 at 14:54, Richard Ji wrote: >> >so my question is, are there things you can do >with external procedures that you cant do with >java? >> >> Yes there are, for instance, Java doesn't support >raw socket, so if you ever need that >> you will have to do it in C with external >procedure. But what's the chance of anyone >> is going to use such a thing, very little. In >general though, you can do most of the >> stuff in Java Stored Procedures. >> >> Richard Ji -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
