Re: more confusion with debugging

"Gillian Klee" <gillian_klee_at_hotmail.com> schrieb im Newsbeitrag news:tD45a.5672$Lq.436948_at_stones...
> Hi again,
>
> I've now tried putting System.out's in my Java stored procedure, and doing
a
> call to dbms_java.set_output() in SQLPlus. However, I'm not getting any
> output - below is what I type into SQLPlus, could someone please tell me
> where I'm going wrong?
>
> SQL> set serverout on
> SQL> call dbms_java.set_output(5000);

Hi,
I had similar problems with getting output from Java procedure. Try to use:

set serverout on SIZE 5000
call dbms_java.set_output(5000);

before you have any calls to your trigger, then perform actions necessary to trigger it and finally issue

call dbms_java.set_output(5000);

In my case this dumps all the Java output that was made since last dbms_java call.

Regards.

Alexei

>
> Call completed.
>
> SQL> CREATE OR REPLACE TRIGGER Trg_Email
> 2 AFTER UPDATE OF UpdateStatus
> 3 ON Tbl_Unit
> 4 FOR EACH ROW
> 5 WHEN (NEW.UpdateStatus='GA')
> 6 CALL mailTranslators
> 7 /
>
> Trigger created.
>
> (my stored procedure is supposed to send out an email - I know the code
> works as a standalone application, but nothing happens here...)
>
> Thanks again,
> Gillian
>
>
Received on Thu Feb 20 2003 - 09:14:31 CST