This was in another thread but I wanted to post it to a separarate
thread so more people might see it..
I need to create oracle functions from within CFML.
Ie:
CREATE OR REPLACE FUNCTION year (MyDate DATE) RETURN NUMBER IS BEGIN
RETURN extract(YEAR FROM MyDate);
END year;
/
It doesn't g
user_objects where object_type = 'FUNCTION' and
object_name = 'YEAR'
select year(sysdate) from dual
/t
>-Original Message-
>From: Rick Root [mailto:[EMAIL PROTECTED]
>Sent: Thursday, February 03, 2005 5:05 PM
>To: CF-Talk
>Subject: Creating Oracle Functions
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
5 matches
Mail list logo