Re: Forms error_text exception


<pwu@xxxxxxxxxxxxx> wrote in message
news:1137477415.918071.238940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm using Oracle Forms 6i.
>
> I want to write a message to a table log whenever there is an error in
> any trigger's PL/SQL code.
>
> I have a forms trigger WHEN-NEW-FORM-INSTANCE which has PL/SQL code:
>
> declare
> .....
> begin
> exception
> when others then
> insert into log values (ERROR_TEXT||' -
> WHEN-NEW-FORM-INSTANCE);
> end;
>
> The code in the WHEN-NEW-FORM-INSTANCE trigger generates an error.

what is the error?

>
> I get a blank error-text on table log despite the fact that the Forms
> reference manual says that the function ERROR_TEXT can be called at
> any time.

the problem may be that you've got it embedded in the INSERT statement; you
may need to assign it's value to a variable and use the variable in the
INSERT statement;

++ mcs


.

Relevant Pages

  • Re: Avoiding Duplicate Inserts
    ... > I am trying to check if a primary key already exists in a table ... > (Oracle 9i) having a few millions of records. ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: Unable to Delete table
    ... > New feature in Oracle you can use mixed case for table name ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Re: info about Oracle session
    ... > where can I find information about tables which I open during the session ... you don't 'open' tables in Oracle, so if you're thinking about needing this ... Prev by Date: ...
    (comp.databases.oracle.tools)
  • Re: pkg_utils ?
    ... > Has anyone here ever come across a PL/SQL package called pkg_utils? ... did you google 'oracle pkg_utils'? ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Sybase and materialized views
    ... Multiple tables aren't an issue with Oracle for Materialized Views. ... Galen Boyer ... Prev by Date: ...
    (comp.databases.sybase)