Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Update in Oracle Function.
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
![]() |
![]() |