Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fibonacci function

user5108636Apr 11 2016 — edited Apr 11 2016

create or replace function fibonacci(n binary_double) return binary_double is

begin

  if n<=2 then

     return 1;

  else

    return fibonacci(n-2) + fibonnaci(n-1);

  end if;

end fibonacci;

/    

getting this error when I compile/run using sql developer. Please suggest

Error(6,29): PLS-00201: identifier 'FIBONNACI' must be declared

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2016
Added on Apr 11 2016
6 comments
1,793 views