Thread: creating trigger

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.

In simple words, I need to create a trigger.  Can anyone help me in
doing this.  BTW, what is similar fxn. as dbms_output.println() in
Oracle.

Thanks in advance.

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