Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: more confusion with debugging
Thanks for the suggestion Alex, but still nothing is happening... has anyone
else got an alternative suggestion?
Thanks,
Gillian
"Alex" <atnite_at_freemail.ru> wrote in message
news:b32rcm$4be$1_at_rznews2.rrze.uni-erlangen.de...
>
> "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 - 12:02:48 CST