If they are not part of a package(only say that because of the other emails referencing possibly being in a package) you could do something as simple as: SELECT MY_FUNCTION() FROM dual
I use a lot of different custom Oracle functions to do the things many would normally do with ColdFusion but have to due to the framework in use here. For example I might have a query that does something like: SELECT ID, DISPLAYVALUE, YESNOFORMAT(ISACTIVE) ACTIVE FROM MYTABLE Then also use custom functions for other things such as treating a comma seperated list as a table in my FROM clause. On 4/25/06, Shawn McKee <[EMAIL PROTECTED]> wrote: > > Integers, strings, etc. A single value for a given function. > > -----Original Message----- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 25, 2006 11:33 AM > To: CF-Talk > Subject: Re: Stored procedures > > > What do the functions return? > > On 4/25/06, Shawn McKee <[EMAIL PROTECTED]> wrote: > > > > I have used lots of Oracle stored procedures using <cfstoredproc> but my > > DBA > > has now written several functions that I need to use. I have never had > > any > > luck accessing these via <cfstoredproc> and was wondering if it was a) > not > > possible or b) there is some clever trick involved. Using MX 6.1 on > > Linux. > > > > Thanks, > > > > Shawn McKee > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238648 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
