Hi,
thanks for the help, it actually was the DBMS_OUTPUT. I put it in for
debugging purposes, but of course I forgot to take it out again ;).
--
Regards,
Stefan Jahnke
BOV AG
@:D2 Vodafone, Abt.: FIBM
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stefan Jahnke
IN
You nailed it Don, I saw the same thing.
You cannot use DBMS_OUTPUT in a function
called by a SQL statement, regardless of pragma
statements.
I've tried it before, couldn't do it. This was on pre
8i versions of Oracle however. The rules have
changed on 8i, it may work.
Jared
On Tuesd
Tim,
small update, one can't specify pragma for standalone functions ... it is
determined automatically by Oracle at-least till 8x, I am not sure about 8i.
Pragma can only be specified for functions in a package.
I believe the problem is with DBMS_OUTPUT, if you take it out, the function
will wo
Do what the action says...add the pragma. Consult your fine manual (or at least it's
electronic equivalent on CD) for more details.
>>> [EMAIL PROTECTED] 05/08/01 10:25AM >>>
Tim Sawmiller schrieb:
>
> oerr ora 6573
> 06573, 0, "Function %s modifies package state, cannot be used here"
> //
May be naive, but it seems to me that
DBMS_OUTPUT.ENABLE(64000);
must be altering the state of the DBMS_OUTPUT package -- and it doesn't seem to be
needed by the funciton -- why not try without it?
Stefan Jahnke wrote:
> Hi,
>
> I get this error if I give a (standalone) function in a where cla
Tim Sawmiller schrieb:
>
> oerr ora 6573
> 06573, 0, "Function %s modifies package state, cannot be used here"
> // *Cause: There are two possible causes for this message:
> // * A SQL statement references a packaged, PL/SQL function that
> //does not contain a pragma co
Here is what Oracle says:
06573, 0, "Function %s modifies package state, cannot be used here"
// *Cause: There are two possible causes for this message:
// * A SQL statement references a packaged, PL/SQL function that
//does not contain a pragma containing the 'Write no P
oerr ora 6573
06573, 0, "Function %s modifies package state, cannot be used here"
// *Cause: There are two possible causes for this message:
// * A SQL statement references a packaged, PL/SQL function that
//does not contain a pragma containing the 'Write no Package
//
