bm8v@newton.acc.Virginia.EDU (Dev Mukherjee) (04/10/91)
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) tony@edm.isac.CA (Tony Schiebel) (04/15/91)
>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>; Try : when others then <barf out an error> >end case; >The error-message I am getting is: >ORACLE error occured while trying to perform POST-CHANGE trigger. Do a show function keys when you get the error. Hit the key that is bound to <display error>. This will give you more info. on the error. --------- Tony Schiebel ISA Corp. tony@edm.isac.ca Edmonton, Alberta, Canada -- Steve Hole mail: steve@edm.isac.ca ISA Corp. uucp: !{uunet, alberta}!ncc!isagate!steve Edmonton, Alberta, Canada phone: (403) 441-4121