Oracle PL/SQL/Object Oriented Database/NOT INSTANTIABLE

Материал из SQL эксперт
Перейти к: навигация, поиск

instantiate shape error

   <source lang="sql">

SQL> SQL> create or replace

 2  type shape as object(number_of_sides number, not instantiable member function calculate_area return number
 3    )
 4  not instantiable not final
 5  /

Type created. SQL> SQL> SQL> SQL> declare

 2   l_shape shape;
 3  begin
 4   l_shape := shape( 2 );
 5  end;
 6  /
l_shape := shape( 2 );
           *

ERROR at line 4: ORA-06550: line 4, column 13: PLS-00713: attempting to instantiate a type that is NOT INSTANTIABLE ORA-06550: line 4, column 2: PL/SQL: Statement ignored

SQL> SQL>

</source>