in reply to DBI oracle sqlcode -20219

Oracle Error Documentation Errors in the range -20999..-20000 are application-defined errors generated by calling the RAISE_APPLICATION_ERROR() stored procedure. If you're just updating a table then the update must be setting off a trigger that raises the -20219 error.

Replies are listed 'Best First'.
Re^2: [OT] DBI oracle sqlcode -20219
by Anonymous Monk on Jan 27, 2005 at 02:33 UTC

    I don't think there is a trigger, but I will check tomorrow. One thing though, this table has foreign key defined, don't know whether this matters?

[reply]

      Guess irrelevant, as the update statement does not change any of the foreign key ;-)

[reply]
Re^2: [OT] DBI oracle sqlcode -20219
by Anonymous Monk on Jan 27, 2005 at 17:58 UTC

    Thanks. There was a trigger.

[reply]

In Section Seekers of Perl Wisdom