Re: Oracle stored procedure security and Java

When a stored procedure executes you shadow session on the server runs the procedure. For UNIX servers in your shadow processes address space, for NT your shadow threads local storage (but withing the ORACLE73.EXE's address space). If your shadow dies then it should not affect the overall running of Oracle, the are cases where core dumps can take out the background processes/thread but these are oracle bugs and should be very few and far between. Many hundreds of thouands of customer use Stored Procedure for their mission critical apps and feel them to be secure.

As for Java stored procedures, only oracle lite supports server side java stored procedures/triggers, expect to see these in the mainstream edition in 8.1 (early next year).

Regards
David Russell

hhshen_at_yahoo.com wrote in message <6idnqj$uta$1_at_nnrp1.dejanews.com>...
>When Oracle executes a stored procedure, does it create a new process to
>execute the procedure, or does the stored procedure run within the address
>space of the server engine? In the later case, how secure is the
 invocation
>of the stored procedure if it contains bugs -- will it screw up the server?
>
>Another question: Does Oracle support Java-based stored procedure? If yes,
>how is its performance?
>
>Any information is appreciated.
>
>Thanks.
>
>hhs
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sat May 02 1998 - 00:00:00 CDT