Hard One....Bizarre "No Data Found" Anomaly

[Quoted] Hello gurus,

[Quoted]     I have a function that I've written to calculate a value based on 3 incoming parameters, and it works fine. : )

    I also have an old function that works fine, but returns the wrong values. I don't need to use this one.

    The problem lies at http://www.worldcupfishing.com/wcf/points_proc I [Quoted] [Quoted] have a form that is displaying the values of this function. It is currently [Quoted] displaying the old function without problem, but when I try to use the new [Quoted] function, it raises an error :

[Quoted] ORA-01403: no data found
ORA-06512: at "DOGFISH.POINTS_CALC_FUNC", line 44
ORA-06512: at "DOGFISH.POINTS_PROC_JOE", line 62

[Quoted] points_calc_func is the new function that I am using (the code is inserted [Quoted] [Quoted] later....) which works fine outside of the calling procedure (i have it in [Quoted] other procs that don't display it to the net, and they work fine) [Quoted] points_proc_joe is the same as the points_proc that exists already(see url [Quoted] above) except that it calls the new function instead of the old one.

[Quoted] [Quoted]     Can anyone offer some insight to this issue? I'm stumped. I've been at [Quoted] it for days (I hope it isn't something simple I'm overlooking....)

Here's the function:

[Quoted] [Quoted] create or replace function points_calc_func

[Quoted]  ( in_length  inches.inch_number%type
 , in_state   record_lengths.state_code%type
 , in_specie_id  specie_formulas.specie_id%type)

 co_efficient         specie_co_efficients.co_efficient%TYPE;
 points_formula     specie_formulas.formula%TYPE;
 var                      VARCHAR2(100);
 val                     VARCHAR2(100);
 num                     NUMBER;
 current_year         number := 2000;

[Quoted] <<snip....cursors for local variables....>>

BEGIN
[Quoted] --determine co_efficients based on state
 open c_co_efficient;
 fetch c_co_efficient into co_efficient;  close c_co_efficient;

--determine formula

 open c_formula;
[Quoted]  fetch c_formula into points_formula;
 close c_formula;

--CALCULATE!!!

[Quoted]  SELECT replace(points_formula,'in_length',in_length)  INTO var
 FROM specie_formulas
 WHERE year LIKE current_year
 AND specie_id LIKE in_specie_id
 ;

[Quoted]  num := round((co_efficient * eval.do_it(points_formula, in_length)),8);

 return num;
[Quoted] END points_calc_func;
/

And the call to the function:

[Quoted] l_points := Points_calc_Func(p_inch_number,p_specie_id,p_state_code);

[Quoted] Thank you for your help.....all input is appreciated!! If you need anymore [Quoted] info....just drop me a line.

--

Joseph Ranseth - Webmaster
World Cup Fishing
[Quoted] [Quoted] Phone:(204) 944-8945 Fax: (204) 943-0954 http://www.worldcupfishing.com Received on Tue Jul 11 2000 - 00:00:00 CEST