How to return value from Oracle function to coldfusion?.

Below is oracle function:

e.g:
pm_outlet_id=210 (number)
pm_part_no=15601-87Z01-000 (varchar)


---------------------------
Function Get_Price (pm_outlet_id IN Number,pm_part_no IN Varchar2)
Return Number Is

v_price Number(10,2);

Begin
BEGIN
Select nvl(unit_list_price,0)
Into v_price
From Pos_Price_Lists_Ext_V price,
Pos_Customers_V cust,
Wcs_Outlet_Master_Test dlr
Where cust.customer_number = dlr.outlet_code
And price.price_list_name = cust.pos_price_list
And price.org_id=13
And price.part_no = pm_part_no
And dlr.outlet_id = pm_outlet_id
And trunc(price.start_date) <= trunc(sysdate)
And (trunc(end_date) >= trunc(sysdate) or end_date is null);

Exception When No_Data_Found Then
v_price :=0;
End;
Return(v_price);
End;

----------------------------

Oracle function will passed 8.9 as answer. The problem is how coldfusion can read value 8.9 from oracle function as output. What coding can use??. If anybody know..pls help me...I'have tried using cf tag cfstoredproc but still have error...

still blur what u want... ape output yg you nak sebenarnye

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

Output: v_price= 8.9. Ini yg i nak. I dah try cfstoredproc,cffunction,cfcomponent untuk panggil function dr oracle tp still tak keluar output. Kalau u tahu..sila lah bagitau.

u nak set v_price = 8.9?
cam tu ke?

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds

yes....

using

1) cfquery for the oracle
2) cfouput for the math function
3) cfset the result for variable

__________________
I hate when:

vBulletin Message:
Sorry! The administrator has specified that users can only post one message every 60 seconds