Alternatives to cfstoredproc tag

[jwdcfdeveloper]

I need to run an Oracle function in CFMX. Is there another way to run a function other than selecting from dual and the cfstoredproc tag? I run into two problems respectively:

1. When selecting from dual, the function I am using calls another function behind the scenes is suppose to populate a table and this does not occur using a select statement

2. When I use the cfstoredproc tag I get ora-01008 - not all variables are bound errors, which I don't understand because I supply a variable that is used in several other queries before the problem cfstoredproc tag and work just fine.

If anyone can shed some light on this issue, I would appreciate it.

Thanks,

JW

 

[ecobb]

A google search on "ora-01008 - not all variables are bound" returned a few hundred results.

http://www.google.com/search?hl=en&q=ora-01008+-+not+all+variables+are+bound+&btnG=Google+Search

When you say "function", are you talking about an actual Oracle function (like [maroon]LEFT(VarName, 5)[/maroon]), or is it a UDF?



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[jwdcfdeveloper]

I mean actual Oracle function.