Friday, 25 May 2012

Which datatypes can be used within functions that can be invoked in SQL statements? | PL SQL

Stored functions can use valid SQL data types, such as NUMBER, VARCHAR2, and DATE. However, they cannot use PL/SQL data typesy, such as BOOLEAN, RECORD, and TYPE.