Re: newbie: debugging Java stored procedures

From: Tim X <timx_at_spamto.devnul.com>
Date: 20 Feb 2003 18:27:07 +1100
Message-ID: <87isvfo1is.fsf@tiger.rapttech.com.au>

>>>>> "Gillian" == Gillian Klee <gillian_klee_at_hotmail.com> writes:

 Gillian> Hi there, Does anyone know if there's a way to debug Java
 Gillian> stored procedures? I have a trigger that fires on a certain
 Gillian> condition in the database, which calls this
 Gillian> procedure. Neither have errors, but nothing happens when my
 Gillian> trigger condition occurs.

 Gillian> Is there a way to tell 1. if my trigger fired, 2. if it

 Gillian> called my stored procedure and 3. if my stored procedure  Gillian> attemted to execute?

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).

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!

Received on Thu Feb 20 2003 - 01:27:07 CST