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
Post a Comment