Re: c based external procedures vs. Java Stored Procedures

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, rgaffuri_at_cox.net 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: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
> 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).