Re: newbie: debugging Java stored procedures

From: Gillian Klee <gillian_klee_at_hotmail.com>
Date: Thu, 20 Feb 2003 12:07:32 -0000
Message-ID: <ex35a.5621$Lq.436380@stones>

Thanks very much for your help guys, I'll try your suggestions. I've now figured out that my trigger is in fact firing (causing my stored procedure to be called), but that something's not right in my procedure so it's not working. Now hopefully I'll be able to tell what is causing this.

Thanks again,
Gillian

> You can use the standard technique of putting print statements inside
> your stored procedure. With java, if you just put System.out.println
> calls in your code it will output to the logfile or trace file (can't
> remember). However, if you do a call to dbms_java.set_output(), the
> output from a println will be displayed in sqlplus (this procedure is
> like using set serveroutput on in sqlplus for plsql).
Received on Thu Feb 20 2003 - 06:07:32 CST