Re: Function Update Table

Just search for autonomous transaction or PRAGMA autonomous_transaction.

Shouldn't be too difficult.

Regards,

Sybrand Bakker, Oracle DBA

"cljlk" <cljlk_at_hotmail.com> wrote in message news:99khfe$h8e$2_at_bob.news.rcn.net...
> 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:39:08 CST