Updating a table with a function call - pragma problems!

I would like to make an update to the database using a function, like this:

UPDATE table

   SET table_val = my_function (col_name)  WHERE table_num = 1;

The problem that I am running into is that I would like to call a procedure inside of my_function. But when I try doing this, I violate the pragma that I have defined for my_function:
PRAGMA RESTRICT_REFERENCES( my_function, WNDS, WNPS)

Is this because the function has to look at the database to call the procedure?

Does anybody have any suggestions on how I can call the procedure from the function? I would like to avoid using cursors if at all possible.

Thank you!
Julie
jkapsa_at_sccme.com

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 13:16:38 CST