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 c
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 ex
>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
Anything stored is always easier to configure then anything external. It
shouldn't be
easier to use, though. And you should judge where dies it make sense. For
reading a
simple file 10 times a day (document scanning application at my previous
company),
a properly written C program (using fork,
We have tested a product this winter that was using an external C proc to
call cobol programs.
Stephane
-Original Message-
Jared Still
Sent: Thursday, September 04, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
One thing you can do is bypass all of your security if
you aren't
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
Depends on your developers. We have few JAVA developers, but quite a few C
programmers. Plus I've got this great book of math routines in C.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, September 04, 2003 10:49 AM
To: Multiple recipients of l
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
