Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!swrinde!elroy.jpl.nasa.gov!decwrl!mcnc!uvaarpa!murdoch!usenet
From: bm8v@newton.acc.Virginia.EDU (Dev Mukherjee)
Newsgroups: comp.databases
Subject: ORACLE Problem: Creating Menus with SQL*Forms.
Keywords: ORACLE, SQL*Forms, Menus...
Message-ID: <1991Apr9.175633.16820@murdoch.acc.Virginia.EDU>
Date: 9 Apr 91 17:56:33 GMT
Sender: usenet@murdoch.acc.Virginia.EDU
Distribution: na
Organization: University of Virginia
Lines: 27
Ireallyam: bm8v


I am trying to use SQL*Forms (v. 2.0.21) to design a front-end menu, which 
branches out to different forms according to the users' choice.

I have four choices (essentially four other forms); and I use a POST-CHANGE
trigger on the menu_choice field to call the forms.  The trigger I use is:

#exemacro  case  <formname>.<menu_choice> is
          when '1' then call <form-1>;
          when '2' then call <form-2>;
          when '3' then call <form-3>;
          when '4' then call <form-4>;
end case;

The error-message I am getting is:

ORACLE error occured while trying to perform POST-CHANGE trigger.

I am at a loss as to why I am getting this message.  ANY HELP, that might
get me out of this mess will be appreicated.

Thanks in advance.

---
Dev Mukherjee
McIntire School of Commerce           bm8v@newton.acc.virginia.edu 
University of Virginia                bm8v@virginia  (bitnet)