Catching NO_DATA_NEEDED Exception in Pipelined Functions

Pipelined Functions are functions whose output is referenced as a table in a SQL statement. Here's an example of a simple pipelined function: -- Prefix: Create supporting objects create or replace type emp_info as object ( ename varchar2(255), jo...