Re: Function 'myfunc' may not be used in SQL
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 10 Oct 2008 11:42:28 +0200
Message-ID: <48ef2383$0$195$e4fe514c@news.xs4all.nl>
Date: Fri, 10 Oct 2008 11:42:28 +0200
Message-ID: <48ef2383$0$195$e4fe514c@news.xs4all.nl>
"Kevin S" <SearleK_at_googlemail.com> schreef in bericht
news:9816723e-24d2-42c6-b29d-8f8b5731bae2_at_s1g2000prg.googlegroups.com...
> 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