Re: Function Update Table

From: Rob Fegan <l120bj_at_aol.com>
Date: 17 Feb 2001 12:21:53 GMT
Message-ID: <20010217072153.03038.00000545@ng-fd1.aol.com>

>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