Hello,
Works for me, but only without the trailing slash (with slash the func
is created but invalid). Do you have the appropriate privs in Oracle?
CREATE OR REPLACE FUNCTION year (MyDate DATE) RETURN NUMBER IS BEGIN
RETURN extract(YEAR FROM MyDate);
END year;
select * from user_objects
Rick,
Just tried it out, and I'm with Tanguy... It works if you leave out
the "/". The Oracle user I tried with had the resource and connect
roles granted to it. This was on Oracle 8.1.7.4.
Andrew
On Thu, 03 Feb 2005 11:05:01 -0500, Rick Root <[EMAIL PROTECTED]> wrote:
> This was in another
Also, make sure that the data source you are using allows you to create
objects. Under allowed SQL, the create box needs to be checked.
>On Thu, 03 Feb 2005 11:05:01 -0500, Rick Root <[EMAIL PROTECTED]>
>wrote:
> > This was in another thread but I wanted to post it to a separarate
> > thread s
It should be IS, not AS.
This also worked for me in a .cfm template. However, putting it in a CFC
broke it in the way you described. As annoying as it is, this has been a bug
with CF for a while; PL/SQL needs to be put into a CFC in one of two ways:
1) all on one line (no carriage returns, so
4 matches
Mail list logo
