Table structure:
SQL> desc emp_test
Name Null? Type
----------------------------------------- -------- ----------------------------
EMPNO NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
DML_TIME VARCHAR2(20)
create or replace package pkg_dml as
global_charvar_01 varchar2(100);
global_charvar_02 varchar2(100);
global_numvar_01 number(20);
global_numvar_02 number(20);
global_datevar_01 date;
global_datevar_02 date;
--
function dml_emp_table (dml_id in varchar2,
p_empno in emp_test.empno%type,
p_ename in emp_test.ename%type default null,
p_job in emp_test.job%type default null,
p_mgr in emp_test.mgr%type default null,
p_hiredate in emp_test.hiredate%type default null,
p_sal in emp_test.sal%type default null,
p_comm in emp_test.comm%type default null,
p_deptno in emp_test.deptno default null,
p_dml_time in emp_test.dml_time%type default null)
return varchar2;
end;
/
SQL> /
Warning: Package created with compilation errors.
SQL> show errors
Errors for PACKAGE PKG_DML:
LINE/COL ERROR
-------- -----------------------------------------------------------------
9/3 PL/SQL: Declaration ignored
17/41 PLS-00488: 'EMP_TEST.DEPTNO' must be a type
EDIT: my bad... i overlooked it to add %type after deptno, now i have made correction as: p_deptno in emp_test.deptno%type default null and compiled successfully