Ryan I'm no expert either. What I heard is that the advantage of external procedures were good where you have something that needs the performance of the underlying system. The C code runs directly on the server, whereas Java is on top of Oracle, which is system-independent.
Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, September 04, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Ive just started digging into these. Im familiar with Java and C, though Im hardly an expert. It appears that java stored procedures are much easier to use and far more forgiving than C based external procedures. So then I started looking for functionality that external procedures have over java and I cant find any. Since I cant find any, I dont see any reason to spend time learning how to use them. so my question is, are there things you can do with external procedures that you cant do with java? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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).