CF and Oracle Function Issue

All, I have a someone that’s an Oracle programmer learning CF. She has an Oracle Function that when ran returns a dataset. I’ve never seen this done before but in Toad it works. i.e. select coldfusion.PC.F_GET_Info(sysdate-275,'F','Y') from dual How can I run this in ColdFusion then

Re: CF and Oracle Function Issue

cfquery name=getFunction... select coldfusion.PC.F_GET_Info(sysdate-275,'F','Y') from dual /cfquery As long as it has the right grants applied to it, you should be able to run it just like that. -Deanna On 3/29/07, James Blaha wrote: All, I have a someone that's an Oracle programmer

Re: CF and Oracle Function Issue

Deanna I tried that. Is is a odd function in oracle 9i and above you can return recordsets in function calls. This function call actually return bascially 3 columns of data with 1 or more possible rows of data. Its kind of like putting a table in a database field. Error Executing Database

Re: CF and Oracle Function Issue

You may have to rewrite the function so that it's a stored proc that uses a ref cursor for the return result, which you can then get with cfstoredproc. On 3/29/07, James Blaha [EMAIL PROTECTED] wrote: Deanna I tried that. Is is a odd function in oracle 9i and above you can return recordsets

Re: CF and Oracle Function Issue

James, Thank you very much! We are working on the code now. Take care, -Jim ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial

Re: CF and Oracle Function Issue

You may have to rewrite the function so that it's a stored proc that uses a ref cursor for the return result, which you can then get with cfstoredproc. You'll find this helpful... http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_17938

Re: CF and Oracle Function Issue

Craig, Thank you very much. Now I just need the learn the Oracle side. Thank you very much for your post and link! Take care, -Jim ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new