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

Home -> Community -> Usenet -> c.d.o.server -> Re: Update in Oracle Function.

Re: Update in Oracle Function.

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: Mon, 1 Nov 1999 15:46:08 -0000
Message-ID: <7vkclg$8k7$1@ezekiel.eunet.ie>


You can only query the database using Oracle Functions. You need to convert your function into a procedure.

Sudheer K G wrote in message <7vect8$8ls$1_at_nnrp1.deja.com>...
>Hello All,
>
>Is it possible to write an update statement in an Oracle Standalone
>Function? When I tried it gave me the error "ORA-06571: Function X_UPD
>does not guarantee not to update database" What does it really mean? Is
>it any other way to do this using functions? (ORACLE 7.3)
>
>Appreciate all the helps..
>
>Sudheer
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Nov 01 1999 - 09:46:08 CST

Original text of this message

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