Database function

[MartinThorpe]

Hello. I have a function in a package in an Oracle database.

Running CFMX 6.1 I have been trying to use CFSTOREDPROC to no avail.

The problem I am experiencing is I am getting oracle error codes complaining
about the bindings of variables. I am thinking it is to do with the function
return in the database function.

Is there a best preactice way to call functions, within a package, in a
database? Using cfquery or not or what?

Thanks for reading

cheers
Martin

[MartinThorpe]

OK looking further through the forums I have seen that someone has solved the
problem, link below. The way round it is to create an Oracle procedure that
calls the function.


[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=1025411&highlight_key=y&keyword1=function