Soundar wrote:
> Hi all,
>
> I'm trying to create a trigger.
>
> I created a function which returns a count of the rows. I used this
> procedure while creating the trigger. But, I get an error stating SQL
> must return opaque. I tried the same with returning a varchar. I get
> the same error again.
I vaguely recall that functions directly invoked by triggers must return
opaque types.
But you can call a function from within that function to get a count.
Not sure what you want to do with the count once you have, though...
Cheers,
Ed Loehr