Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: 9i streams vs triggers
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
![]() |
![]() |