Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Function Update Table
>Subject: Function Update Table
>From: algis_at_go2.pl (Algis)
>Date: 2/17/01 11:39 AM GMT Standard Time
>Message-id: <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;
>
>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
Hi Algis,
As far as I'm aware Oracle will not let you do this. They even specifically
force you to qualify packaged functions as not updating base tables before such
can packaged functions can be used within a select statement.
Regards,
Rob
Received on Sat Feb 17 2001 - 06:21:53 CST