Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 9i streams vs triggers

Re: 9i streams vs triggers

From: Sebastiano Pilla <etechweb_at_yahoo.com>
Date: Sun, 12 Jan 2003 15:40:32 +0100
Message-ID: <1fooca6.9ffo6e53u7mhN%etechweb@yahoo.com>


servant <mjohns1_at_uhc.com> wrote:

> My main concern with the complexity is to be able to call my existing Java
> classes so I don't have to write the business rules twice. It is my
> understanding that I can write Java in PL/SQL so this may work. I am being
> told that the massaging is not simple but I am going to assume it is not
> rocket science either.

Not exactly, you can write a stored procedure in Java and then you wrap it with a PL/SQL call specification, such that other PL/SQL code fragments can call your Java stored procedure. I don't have the link handy, but go to <http://tahiti.oracle.com/> and search for the JDBC Developer documentation.

If you end up buying Thomas Kyte's excellent "expert one-on-one Oracle" book, you'll find examples in chapter 19.

Sebastiano Pilla Received on Sun Jan 12 2003 - 08:40:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US