To do this, you need Oracle 8.1, and
then you can use AUTONOMOUS transactions.
These can be a little counter-intuitive in use,
so think carefully when using them.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Practical Oracle 8i: Building Efficient Databases
Publishers: Addison-Wesley
Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
Algis wrote in message <904B86027algisgo2pl_at_213.25.200.9>...
>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;
>
Received on Sat Feb 17 2001 - 06:35:00 CST
