Re: Function 'myfunc' may not be used in SQL

From: Shakespeare <>
Date: Fri, 10 Oct 2008 11:42:28 +0200
Message-ID: <48ef2383$0$195$>

"Kevin S" <> schreef in bericht
> Daniel
>> Then what you posted is not your real code so no further
>> help is possible.
> Please note the sentence in my original posting which states 'I use it
> in a procedure which exists in the same package as the function...'.
> As such what I have posted is my real code.

No, because this is not:

Update t1
set c1 = myfnc(c2); <-- NO PREFIX, AND YOU SAY YOU USE A PREFIX

AND your error message is
Function 'myfunc' may not be used in SQL. <-- NOTE THE U IN MYFUNC

So this can't be your real code.....

Shakespeare Received on Fri Oct 10 2008 - 04:42:28 CDT

Original text of this message