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: Functions to update database

Re: Functions to update database

From: Bertalan GOMBOS <gombos_at_finit.hu>
Date: 1998/09/07
Message-ID: <35F3C47C.71224D10@finit.hu>#1/1

Hi !

Luis Díez Porres wrote:
>
> Hi,
>
> I need to develop a PL/SQL function that allows me to insert/update a
> table.
> I'm getting an
>
> ORA-06571: function name does not guarantee not to update database

Use restrict_preferences pragma, it may solve your problem.

					Bye:
						Bert
-- 
                                           :
 ----.----,  ------------------------------:----------------------------
   --;----"-----,  ,--------,  ,--------,  |     Bertalan Gombos
     |          |  ;--------'  |           |    software engineer
  ---|----------'  `--------   |           |  bgombos_at_freemail.c3.hu
`----'  ---------------------------------  `------------------------ '98
Received on Mon Sep 07 1998 - 00:00:00 CDT

Original text of this message

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