Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uflorida!ukma!xanth!paterra From: paterra@xanth.cs.odu.edu (Frank C. Paterra) Newsgroups: comp.databases Subject: using triggers in pc oracle forms Keywords: triggers help please Message-ID: <7606@xanth.cs.odu.edu> Date: 10 Feb 89 15:36:46 GMT Organization: Old Dominion University, Norfolk Va. Lines: 16 Hello Netlanders, I'm having a problem with sqlforms on the pc version of oracle. Every things seems to work ok until I use a trigger that has a #EXEMACRO statement in it. I've tried #exemacro exeqry, #exemacro nxtblk, and lots of others, but whenever it gets to the #exemacro statement I get the error "SQL error in processing post-field trigger". I've tried using post-field, post-change, and pre-field triggers, but the result is the same. My company did not purchase the telephone support so oracle can't give me any help. What might I be doing wrong?? Thanks for the help Frank Paterra paterra@xanth.cs.odu.edu