Calling Covered Methods

• Covered Methods can be called from SQL and PL/SQL

  • From Select statements

select years_employed (startdate) from emp

• Using the new CALL syntax

call years_employed(d) into n

• Just like a PL/SQL stored procedure

begin n := years_employed(d); end;

Previous slide

Next slide

Back to first slide

View graphic version