oracle - PL/SQL functions with one parameter -


i wondering if help.

i'm @ wits end this.

i want create function take 1 parameter.

here code. keep getting error when run:

error(3,19): pls-00103: encountered symbol ";" when expecting 1 of thefollowing:
begin function pragma procedure subtype type current cursor delete exists prior external language

code

set serveroutput on;  create or replace function checkbooktype (   p_book_type  titles.category ) return boolan is;  begin    if (p_book_type = 'business')       return true;    else     return false;    end if;    return v_returnvalue; end checkbooktype; 

least verbose solution:

create or replace function checkbooktype (         p_book_type in  titles.category%type     ) return boolean  begin    return p_book_type = 'business';  end checkbooktype; 

Comments

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

c# - MSAA finds controls UI Automation doesn't -

wordpress - .htaccess: RewriteRule: bad flag delimiters -