Re: Dev2000 Insert and Commit without visible block

Hello Joe.

If you only want to get rid of the message you can set the message_level higher so only severe errors are reported.

This works as follows:
Declare
  old_message_level varchar2(2);
Begin
-- Make your Inserts.
  old_message_level := :system.message_level;
:system.message_level := '20';

• Make your Commit.
  :system.message_level := old_message_level;
  End;

Read about it in the online Help to get more info.

HTH,
Angelo. Received on Fri Jan 30 1998 - 00:00:00 CET