Re: Function Update Table

Is the AUTOONOMOUS a function? Maybe, I haven't gone that far, I could not find it in Oracle doc.

In article <904BBBB07algisgo2pl_at_213.25.200.9>, algis_at_go2.pl says...
>
>jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) napisano w
 <982413080.10828.0.nnrp-
>09.9e984b29_at_news.demon.co.uk>:
>
>>
>>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;
>>>
>>
>>
>>
>
>OK
>I will try this
>Thanks for Help.
Received on Sun Mar 25 2001 - 04:32:14 CST