One thing you can do is bypass all of your security if you aren't careful. EXTPROC needs to run as some user other than Oracle (nobody for instance), otherwise you've just created a huge security breach.
There are other security implications as well. Even running as 'nobody', you need to ensure that the code is written in a secure manner. As for why you would use them, there are probably more reasons than we can think of here. One that comes to mind is you have data that needs massaged by an algorithm in a purchased library. Rather than writing a whole app to deal with it, you write a wrapper for the purchased functionality and plug it into EXTPROC. You can even do this with Perl. Works very well. :) Jared On Thu, 2003-09-04 at 07:49, [EMAIL PROTECTED] wrote: > 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: Jared Still 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).
