Re: Alert check with MFC

From: Gjlinker <gjlinker_at_aol.com>
Date: 07 Feb 1999 09:22:39 GMT
Message-ID: <19990207042239.11568.00000378@ngol03.aol.com>

Dear all,

>My problem is that i can not invoke the NTCCLAF_CheckAlerts function in
>a select statement.
>
>Oracle returns me :
>"select OXY_ALERTS.NTCCLAF_Check_Alert(1) from dual
> *
>ERROR at line 1:
>ORA-06571: Function NTCCLAF_CHECK_ALERT does not guarantee not to
>update database

You have to tell oracle that your function is not changing the database. Use the PRAGMA RESTRICT REFERENCES statement just after your function definition.

Regards Gerrit-Jan Linker,

---

*| Gerrit-Jan Linker : gjlinker_at_aol.com
*| 
*| http://members.aol.com/gjlinker

*| 
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug
*************************************************
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sun Feb 07 1999 - 03:22:39 CST