Re: Forms error 452
From: Frank <frankbo_at_interaccess.nl>
Date: Thu, 12 Oct 2000 16:44:12 +0200
Message-ID: <8s4ioe$63e$1_at_porthos.nl.uu.net>
Date: Thu, 12 Oct 2000 16:44:12 +0200
Message-ID: <8s4ioe$63e$1_at_porthos.nl.uu.net>
Line 13 would be the return(0)?
I do see two end-if's - which would make the error
data dependent: if conditions are such that the 0 would
be returned, the error is likely to occur?
-- Frank Alan <campbela_691021_at_my-deja.com> schreef in berichtnieuws 8s1tce$9bp$1_at_nnrp1.deja.com...Received on Thu Oct 12 2000 - 16:44:12 CEST
> I have a problem with Reports 2.5. Occasionally I get the following
> error :-
>
> REP-0452:unhandled exception (user defined exception)
> which was raised in a statement starting at line 668 of STANDARD called
> from the statement starting at line 678 of STANDARD.
> Called from statement starting at line 13 of CS_1 formular.
>
> The function CF1Formula is shown below :-
>
> function CF_1Formula return Number is
> begin
> IF upper(:P_LETTER_TEXT) = 'ELR008A' and :STATUS = 'AI'
> THEN UPDATE WEDLEV UPD
> SET UPD.STATUS = 'AK'
> WHERE UPD.EVENT_ID = :EVENT;
> COMMIT;
> RETURN (1);
> ELSE IF upper(:P_LETTER_TEXT) = 'ELR008B' and :STATUS = 'AP'
> THEN UPDATE WEDLEV UPD
> SET UPD.STATUS = 'PS'
> WHERE UPD.EVENT_ID = :EVENT;
> COMMIT;
> RETURN (2);
> ELSE RETURN (0);
> END IF;
> END IF;
> end;
>
> This has only started happening since we exported the database from a
> SP unix node to a S80 unix node. The program doesnt appear to be
> happening each the routine is called.
>
> Anyone have any ideas ?
>
> TIA
> Alan
> ---
> Alan Campbell
> alanc_at_mullen.demon.co.uk
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.