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.
We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.