tracker issue : CF-3040231

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 80218:(Watson Migration Closure)You can't call an Oracle PL/SQL FUNCTION - this is one HUGE limitation, at my company, we should be able to reuse our existing PL/SQL codebase, instead of writing new PL/SQL procedures with OUT parame

| View in Tracker

Status/Resolution/Reason: To Fix//

Reporter/Name(from Bugbase): Lolita Gendelman / Lolita Gendelman (gendelml)

Created: 09/29/2009

Components: Database, General

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Platforms All

Vote Count: 1

Problem:

You can't call an Oracle PL/SQL FUNCTION - this is one HUGE limitation, at my company, we should be able to reuse our existing PL/SQL codebase, instead of writing new PL/SQL procedures with OUT parameters, just for ColdFusion. We're evaluating CF 9 now, and I would hate it if this single limitation would cause another product to be chosen, since I have loved and used ColdFusion for many years at other companies
Method:


Result:

This is not a bug but a feature request:  a support for Oracle PL/SQL stored functions!  This feature is deperately needed; it was a big obstacel to using CF at my prior workplaces and it might be a decisive factor as my current company is evaluating CF as its web app development tool of choice. We need to be able to reuse existing Oracle PL/SQL packages and their functions, instead of creating new procedures with OUT parameters! I am a big and loyal fan of CF and am trying to advertise it everywhere I go, but this is one HUGE limitation!  Thank you, Lolita

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3040231

External Customer Info:
External Company:  
External Customer Name: Lolita Gendelman
External Customer Email: 573252C14AB2651C992015A7
External Test Config: 09/29/2009

Attachments:

Comments:

+1 vote. This has caught me out. and it's bloody annoying. In some circumstances one can do this, though: <cfquery> select myFunction() from dual </cfquery> thought. Only works for simple values though. -- Adam
Vote by External U.
22785 | November 11, 2011 12:37:28 AM GMT