Hi Experts,
I know this might be a basic question, below is my piece of code
I have a variable g_number declared as number data type and initialized to 10
I have EMP_SAL_TAB which is of EMP_SAL data type which is defined in line 6.
but am getting error when am trying to initialize it in line 11.
now my query is why am getting error for collection initialization at line 11 ????? sorry for a very basic question, but it is always good to clear a query.
create or replace PACKAGE emp_sal AS
g_salary_spec number;
PROCEDURE find_sal(c_id emp.empno%type);
FUNCTION CONCATE_NAMES (C_ID EMP.EMPNO%TYPE) RETURN VARCHAR2;
type emp_sal is table of char(2) index by binary_integer;
emp_sal_tab emp_sal;
g_number number:=10;
emp_sal_tab(1):= 100;
END emp_sal;