Oracle Forms (MOSC)

MOSC Banner

Need help badly getting this to compile. Please Help.

edited Aug 19, 2013 7:40AM in Oracle Forms (MOSC) 4 commentsAnswered ✓
I am trying to upgrade this form but this trigger is stopping it from compiling. Can someone please help me fix this.

begin
   if :old_number is null or :new_number is null
      then raise form_trigger_failure;
   else SET_APPLICATION_PROPERTY(CURSOR_STYLE,'BUSY');
     update_coos(:old_number,:new_number);
      SET_APPLICATION_PROPERTY(CURSOR_STYLE,'DEFAULT');
      end if;
   exception
      when form_trigger_failure then
      Message('YOU MUST HAVE A PROJECT NUMBER TO CHANGE/UPDATE FROM AND TO');
END;

Here is the error message that I am getting when I try to compile the code above.

Compiling WHEN-NEW-BLOCK-INSTANCE trigger on UPDATE_COOS data block...

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center