June 13, 2012

Using a Variable As Datatype In A Package in Oracle

Using a Variable As Datatype In A Package in Oracle

 CREATE OR REPLACE PACKAGE pkg_xx  
 IS  
   v1 number(10);  
 end;  
  
 sho err  
 CREATE OR REPLACE PACKAGE pkg_yy  
 IS  
   v2 pkg_xx.v1%type;  
 end;