Function Update Table

Hi

Is it possible to update table calling function from SELECT

SELECT function_name FROM DUAL;

where Function my be:

Function
...
Begin
UPDATE table_name SET column_name = 1234;

Return result_name;
End function_name;

It returns only DML error;

I have (tried) tested it with PROCEDURE calling it : EXECEUTE procedure_name;

and it worked corret but I need FUNCTION

Please help me
I need to know is it possible or not?

Thanks for help
Algis Received on Sat Feb 17 2001 - 05:39:06 CST