Re: Using stored function in SELECT statement

From: John Homeyard <homeyard_at_worldnet.att.net>
Date: 1996/05/23
Message-ID: <4o1vph$c8p_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1

Check out the server error reference manual for the ORA-06571 for instructions to solve this error. It envolves changes you must make to the stored procedure to insure that the function does't update the database."Victor Z. Krokhmal" <victor_at_dwayne.FreeNet.Kiev.UA> wrote:
>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 Š Š�€š

John. Received on Thu May 23 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Manish Dalmia: "Calling 'C' routines from Stored Procedures"
In reply to Victor Z. Krokhmal: "Using stored function in SELECT statement"
Next in thread: Morgan Skinner: "Re: Using stored function in SELECT statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message