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;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
