Using stored function in SELECT statement

From: Victor Z. Krokhmal <victor_at_dwayne.FreeNet.Kiev.UA>
Date: 1996/05/23
Message-ID: <AAKVnen0j3_at_dwayne.FreeNet.Kiev.UA>#1/1


Hi there,

I am having difficulty in using stored function in SELECT statement. And next example returns error :
ORA-06571 "Function does not guarantee to not update database".

    SELECT var1 FROM tab1
    WHERE Func1(var2)=0;

Therefore, could anyone out there help me to solve this problem.

Thanks for any advice.

---
€Š Victor Z. Krokhmal Š email: victor_at_dwayne.freenet.kiev.ua Š€ Š Oracle Database Administrator Š phone: +7 (044) 212-54-81 /faxmodem/ Ё

‚Š State Tax Inspectorate - Ukraine Š                                      Š‚
Received on Thu May 23 1996 - 00:00:00 CEST

Original text of this message