On Dec 1, 7:33 am, eteunisse <[EMAIL PROTECTED]> wrote:
> The strange thing is that when I do an insert, all the outpulines do
> appear, only with an update they do not.
> And the updatetrigger does work because I do get the first two
> outputlines.
> I'm lost.
>
> On 1 Dec, 14:14, eteunisse <[EMAIL PROTECTED]> wrote:
>
>
>
> > This is the case:
> > In a procedure which is part of an input/output trigger I put some
> > dbms_output.put_line statements.
> > Nothing strange about that.
> > The first few outputlines do appear correct when I fire an update or
> > insert.
> > But the output lines some statements further in de procedure do not
> > appear any more.
> > There are no IF-statements that prevent them from displaying. (see
> > code beneath)
> > Does anyone have an idea what causes the sudden stop of displaying my
> > outputlines?
>
> > BEGIN
> > lvv_name := mta_br_osn.gcv_pack_name || '.' || lcv_proc_name ;
>
> > lvv_step := 'Controle prioriteit pre-proces';
>
> > dbms_output.put_line ('TEST start'); --this one DOES appear
>
> > IF piv_proces_cd_pre IS NOT NULL
> > THEN
> > dbms_output.put_line ('TEST 00'); --this one DOES appear
>
> > OPEN c_osn_01 (piv_proces_cd_pre);
>
> > dbms_output.put_line ('TEST 01'); --THIS ONE DOES NOT APPEAR!!!
>
> > FETCH c_osn_01
> > INTO lvn_prio_pre;
>
> > dbms_output.put_line ('TEST 02'); --THIS ONE DOES NOT APPEAR!!!
>
> > IF c_osn_01%NOTFOUND
> > THEN
> > CLOSE c_osn_01;
> > lvv_melding := 'Pre-proces niet gevonden';
> > RAISE le_not_found;
> > END IF;
>
> > CLOSE c_osn_01;
>
> > dbms_output.put_line ('TEST 03'); --THIS ONE DOES NOT APPEAR!!!
>
> > IF lvn_prio_pre != pin_prioriteit-1
> > THEN
> > lvv_melding := 'ERROR';
> > RAISE le_fout;
> > ELSE
> > dbms_output.put_line ('TEST 04'); --THIS ONE DOES NOT APPEAR!!!
> > END IF;
> > END IF;- Hide quoted text -
>
> - Show quoted text -
First, post the complete code for the trigger along with the DDL and
sample data for any tables involved with this process. Second, post
the Oracle version you're using, to at least 4 numbers.
When this information is available someone can then help you.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
