I'm trying to create a trigger. The function I'm
using returns the count(*) from a table. But, during
the creation of the trigger, I get an error stating
the function must return opaque. I tried the same
with the function to be returning a varchar. But,
again I get the same error.
In simple words, it's this. I'm trying to create a
simple trigger which just prints out a message (as
dbms_out.println() in oracle) before or after
insertion or updation on a table. Even if it doesn't
print a message, some changes to be made on the table.
Can some one give me a simple example which does it.
Thanks in advance.
__________________________________________________
Do You Yahoo!?
Thousands of Stores. Millions of Products. All in one place.
Yahoo! Shopping: http://shopping.yahoo.com
