begin if p_fk_col_list is null then select case when atc.data_type like '%CHAR%' then atc.data_type || '(' || atc.data_length || ')' when atc.data_type = 'NUMBER' then atc.data_type || decode(atc.data_precision, null, '', '(' || atc.data_precision || decode(atc.data_scale, null, '', ',' || atc.data_scale) || ')') else atc.data_type end into v_datatype from all_tab_cols atc where table_name = p_pk_table and column_name = p_pk_col_list;
But when i am going to execute the function, It is giving me following error:-
ORA-06550: line 1, column 36: PLS-00103: Encountered the symbol ";" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod not range rem => .. <> or != or ~= >= <= <> and or like between || indicator The symbol ")" was substituted for ";" to continue.
Please help me out. I have already wasted alot of time. Thanks in advance.