Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Function Update Table

Re: Function Update Table

From: Rob Fegan <l120bj_at_aol.com>
Date: 17 Feb 2001 13:02:22 GMT
Message-ID: <20010217080222.14596.00000935@ng-de1.aol.com>

>Subject: Re: Function Update Table
>From: "Jonathan Lewis" jonathan_at_jlcomp.demon.co.uk
>Date: 2/17/01 12:35 PM GMT Standard Time
>Message-id: <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;
>>
>

Cheers Jonathan, I didn't realise you could use autonomous transactions in that manner. Thanks for the info.
Regards,
  Rob Received on Sat Feb 17 2001 - 07:02:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US