How can I use PRAGMA?
Date: 1996/09/27
Message-ID: <52hm78$25t_at_mailnet3.rdc.cl>#1/1
I create the following package:
I use the Add_Pkg.Add_Fun function, but the following error appers:
Add table is:
Can I use PRAGMA to avoid this error?
Thanks...
Create or Replace Package Add_Pkg As
oldNumber Number(3);
/* Prototipo de la funcion Add_Fun */
Function Add_Fun (addNumber in Number) Return Number;
End Add_Pkg;
/
Create or Replace Package Body Add_Pkg As
Function Add_Fun (addNumber in Number)
Return Number Is
Pragma "Write No Database State"; /* ???????? */
Begin
If Add_Pkg.oldNumber Is Null Then
Add_Pkg.oldNumber := 0;
End If;
Add_Pkg.oldNumber := Add_Pkg.oldNumber + addNumber;
Return(Add_Pkg.oldNumber);
End Add_Fun;
End Add_Pkg;
/
SQL> select Add_Pkg.Add_Fun(n) from test;
select Add_Pkg.Add_Fun(n) from test
*
ERROR at line 1:
ORA-06571: Function ADD_FUN does not guarantee not to update database
SQL> create table test (n number(3));
Table created.
SQL> insert into test values (7);
1 row created.
--- Marcelo A. Collao Huper. ORDEN S. A.. Miraflores 388, Santiago, Chile. | e-mail : mailto:mcollao_at_orden.cl Tel: (52 2) 68 69 135 | intranet: http://baco.holding.cl/~mcollao/page Fax: (52 2) 68 69 126 | internet: http://www.dcc.uchile.cl/~mcollaoReceived on Fri Sep 27 1996 - 00:00:00 CEST