|
SQL> create or replace package APPLICATION_TYPES is
2 subtype short_varchar2 is varchar2(40);
3 end;
4 /
Package created.
SQL> create or replace procedure MY_PROC(p_input application_types.short_varchar2) is
2 v1 application_types.short_varchar2;
3 begin
4 null;
5 end;
6 /
Procedure created.
SQL> create or replace package MY_PKG is
2 glob_var application_types.short_varchar2 := 'asdf';
3 end;
4 /
Package created.
SQL>
|